Formatting currency in mail merge from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Katherine - 03 Oct 2003 21:16 GMT

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.

Reply to this Message

Peter Jamieson - 04 Oct 2003 08:53 GMT

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" }

--
Peter Jamieson
MS Word MVP

> Hi, I am trying to create invoices in MS Word 2003
> merging with an Access query. The problem is, instead of
[quoted text clipped - 7 lines]
>
> Any help would be greatly appreciated.

Reply to this Message