Microsoft KB Archive/123700

{|
 * width="100%"|

Currency-Formatted Numbers Round When Merged Using ODBC

 * }

Q123700

-

The information in this article applies to:


 * 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} 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 :