Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Confedlady
 
Posts: n/a
Default How do I make currency print correctly in merged document?

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

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default How do I make currency print correctly in merged document?

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

{ MERGEFIELD myfield \*mergeformat }

to

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

Peter Jamieson

"Confedlady" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default How do I make currency print correctly in merged document?

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


--

Graham Mayor - Word MVP

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


Confedlady wrote:
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a front and back text box print correctly in Word? Leigh Page Layout 1 April 29th 06 01:38 AM
print preview and print not showing/printing the entire document Shain Microsoft Word Help 1 March 17th 06 09:11 PM
Large documents linked together do not print the whole document Mary J. Microsoft Word Help 3 September 15th 05 02:42 PM
Opening a word merged document from Access code doesn't update tjmax Mailmerge 0 September 13th 05 03:25 PM
How do I make a 17"x8.5" document with 3 columns print? Office worker Page Layout 1 July 29th 05 09:54 PM


All times are GMT +1. The time now is 03:14 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"