Currency Field not Formatting as such

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dorothy - 09 Sep 2004 14:48 GMT

I have a mail merge form in word that is pulling the info
from Access. One field in Access is a currency field and
in the qry is appears to be formatted as currency, but
when I merge to word the field does not bring over the
currency formatting. How do I format this field. I want
to include 2 decimal spaces. Thanks for you help

Reply to this Message

Doug Robbins - 10 Sep 2004 00:41 GMT

Either set up an expression in the query that uses the format function or
see "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have a mail merge form in word that is pulling the info
> from Access. One field in Access is a currency field and
> in the qry is appears to be formatted as currency, but
> when I merge to word the field does not bring over the
> currency formatting. How do I format this field. I want
> to include 2 decimal spaces. Thanks for you help

Reply to this Message

Rate this thread: