How do I make currency print correctly in merged document?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Confedlady - 03 May 2006 13:17 GMT

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

Reply to this Message

Peter Jamieson - 03 May 2006 14:09 GMT

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

{ MERGEFIELD myfield \*mergeformat }

to

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

Peter Jamieson

>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

Reply to this Message

Graham Mayor - 03 May 2006 15:55 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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

Reply to this Message

Rate this thread: