Merge from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christopher - 29 Apr 2004 21:31 GMT

I have fields in Access Data Typed as "currency". When I merge these fields into Word, they don't appear as currency. Zeros are left off and the Dollar sign is missing. Is there a way to get the field to appear in Word ias it does in Access?

Reply to this Message

Les Mercer - 30 Apr 2004 09:21 GMT

If you toggle field codes in Word you will see the field shown as something
like
{MERGEFIELD "price"}
modify it to
{MERGEFIELD "price"\# "$#,##0.00;($#,##0.00)"}
Regards
Les Mercer

> I have fields in Access Data Typed as "currency". When I merge these fields into Word, they don't appear as currency. Zeros are left off and the

Dollar sign is missing. Is there a way to get the field to appear in Word
ias it does in Access?

Reply to this Message

Graham Mayor - 30 Apr 2004 13:05 GMT

Word has changed the way Merges connect to external data sources so now Word
is expected to provide the formatting. You can revert to the old method or
use a field switch - see the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and the page on
formatting linked from that section. For this purpose Excel and Access have
the same issues.

Signature

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I have fields in Access Data Typed as "currency". When I merge these
> fields into Word, they don't appear as currency. Zeros are left off
> and the Dollar sign is missing. Is there a way to get the field to
> appear in Word as it does in Access?

Reply to this Message