Keeping number format when merging into Microsoft Word

[Guest]

I set up a mail merge letter with a small table filling 2 cells with numbers
formated for currency (showing a dollar sign and having 2 decimal places).
When running the source query, it shows the correct formatting. When merged
into the Microsoft Word table it doesn't show the $ sign and it only shows
one decimal. How can I send the complete number format?

 

[Douglas J. Steele]

Try using the Format function in your question, rather than simply setting
the Format property of the field.

 

[Peter Hibbs]

You might also want to have a look at
http://word.mvps.org/FAQs/MailMerge/index.htm
which shows how to format mail merge date type fields in Word.

HTH

Peter Hibbs.