The information in this article applies to:
SYMPTOMSNumbers 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. CAUSEMicrosoft Access is rounding the number before passing it to Word for Windows. STATUSMicrosoft 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 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 |
Last Reviewed: December 29, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |