Currency-Formatted Numbers Round When Merged Using ODBC

Q123700

The information in this article applies to:

SYMPTOMS

Numbers formatted as currency and written to the thousandths (for example, 123.875) in Microsoft Access are rounded to the nearest hundredths (123.88) when merged to Microsoft Word using ODBC. (This behavior does not occur if you are merging a Microsoft Access database using DDE.) The expected behavior is for the number to not be rounded.


CAUSE

Microsoft Access is rounding the number before passing it to Word for Windows.


STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0 for Windows. This problem was corrected in Word version 7.0 for Windows 95.


WORKAROUND

To keep the number from rounding when merged to Word, open the database in Microsoft Access, and change the formatting for the number to a general number format. Although this format removes the dollar sign, you can correct this in Word by using one of the following methods:

Method 1: Include a numeric picture switch in the mergefield, so that the field looks like this: 


             {mergefield number \# $####,0.00}
Method 2: Place a dollar sign in the main document immediately preceding the mergefield that contains the number.

Additional query words: 6.0 winword mail merge print word6 access $ dollar sign round rounded number currency

Keywords : kbinterop kbmerge
Issue type :
Technology :


Last Reviewed: November 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.