How do I make currency print correctly in merged document?

[Confedlady]

I have my letter set up with merge files. My field in access is set as
currency and I have it entered as $ 65,890.00. When I merge the field prints
as 65890. I know I need a switch, but I can't get it right. Please Help!
Thanks

 

[Peter Jamieson]

Try using Alt-F9 to display the field codes and changing

{ MERGEFIELD myfield \*mergeformat }

to

{ MERGEFIELD myfield \#"$ ,0.00" \*mergeformat }

Peter Jamieson

 

[Graham Mayor]

See http://www.gmayor.com/formatting_word_fields.htm


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>