I have a problem. When I merge my Currency (format in Access) field to my
Word document I get one of two problems depending on my switch. Please do
not refer me to G Mayor website. I have been there and it did not solve my
problem.

If I do not put in a switch and merge just as the field itself I get the
following:
Data in Access: $141.30 Data in Word: 141 3

If I use the switch /# ##,###.00
Data in Access: $141.30 Data in Word 144.00

For some reason if the cents in the currency is X0 then it adds the last
dollar number and the first cents number together. If the cents is XX then
it imports fine.

I know that I can get "around" this by changing the field type in access to
text but I need it to remain currency for my formulas in my access reports to
work.

Please help....

~Di