Format Currency

[Todd K.]

I have a Word merge document pulling from an Access Project view. In the
view, the field [Fund_Amt] is formatted as currency, but when it comes up in
the Word document it's unformatted ($10,000.00 becomes 10000). I looked into
switches, but didn't see one just for regular currency (although the dollar
text one is really cool).

 

[Peter Jamieson]

It's \# . Try

{ MERGEFIELD Fund_Amt \#"$,0.00" }

Peter Jamieson

 

[Todd K.]

YOU ROCK! That works perfectly, thanks.

It's \# . Try

{ MERGEFIELD Fund_Amt \#"$,0.00" }

Peter Jamieson

I have a Word merge document pulling from an Access Project view. In the
view, the field [Fund_Amt] is formatted as currency, but when it comes up
in
the Word document it's unformatted ($10,000.00 becomes 10000). I looked
into
switches, but didn't see one just for regular currency (although the
dollar
text one is really cool).