Mergin from Access2003 to Word 2003

[Joshua K Briley]

Hello,

I just recently upgraded from office 2K to 2K3. I am mergin from the DB to
Word reports. Prior to the switch the merging went fine.

I've changed my regional settings to show three numbers after the decimal
place, in numbers and currency, thinking this would help solve the issue.
Still not working. I've looked at merge formatting and it looks like this:

\#0.000

Is there something else I could be overlooking? Numbers like 0.209 (in
access) are rounding up to 0.210 (in Word after merge). While 0.221 is
rounding down to 0.220. It's essentially truncating the third digit. Does
anyone have any advice? Thanks in advance.

 

[Peter Jamieson]

As a workaround, you may find that reverting to the connection method Word
2000 used by default will do the trick: check Word
Tools|Options|General|"Confirm conversions at open", go through the process
of connecting to your access data source, and choose the DDE option when it
is offered. You may need to remove the \#0.000 switches.

Peter Jamieson

 

[Joshua K Briley]

Seems to have worked. Thanks Peter.