Access/Word Merge

[Guest]

How can you make Access field formats show up in a merged Word document?
(For example, wanting a currency field in Access to show up in a Word
document as currency with 2 decimals)

 

[Douglas J. Steele]

Try using the Format function in a query and merge the query, rather than
setting the Format property in the field.

 

[Peter Hibbs]

You could do the formatting in the Word document itself, have a look
at -
http://word.mvps.org/FAQs/MailMerge/index.htm

which shows how to format mail merge fields in Word.

HTH

Peter Hibbs.