retain access format in word merge document?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick Boon - 04 May 2005 10:18 GMT

How can I retain the Access format in a word merge document?

i.e data format in Access is 'Currency' when merged to Word the currency
format is lost. same applys to 'Date' formats.

Reply to this Message

Graham Mayor - 04 May 2005 10:49 GMT

Use formatting switches in the Word field for the simplest approach -
http://www.gmayor.com/formatting_word_fields.htm
If you want the more complicated approach see the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm (the issues and
workarounds are the same for Access).

Signature

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

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

> How can I retain the Access format in a word merge document?
>
> i.e data format in Access is 'Currency' when merged to Word the
> currency format is lost. same applys to 'Date' formats.

Reply to this Message