Currency-Formatted Numbers Round When Merged Using ODBC

• Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c

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}

          the mergefield that contains the number.