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)

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"NancyH-D" <NancyH-(E-Mail Removed)> wrote in message
news:F25AC386-24A5-4847-9B29-(E-Mail Removed)...
> 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)

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.

On Wed, 28 Mar 2007 13:42:00 -0700, NancyH-D
<NancyH-(E-Mail Removed)> wrote:

>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)