Formatting currency in mail merge from Access

[Katherine]

Hi, I am trying to create invoices in MS Word 2003
merging with an Access query. The problem is, instead of
displaying the clients balance as $1,252.50, Word is
displaying the merged field as 1252.5.

I have tried putting a switch in the field code. I
entered \# $#,###.00 after the MERGEFIELD, which is what
the help menu said to do, but nothing changed. What am I
doing wrong.

Any help would be greatly appreciated.

 

[Peter Jamieson]

Did your MERGEFIELD end up looking lke

{ MERGEFIELD mynumber \# $#,###.00 }

? If not, can you show us exactly what it does look like?

The above switch should work (not sure what is wrong if it does not). If you
can get the sitch to work you might find the following works better:

{ MERGEFIELD mynumber \#",$0.00" }