Merge from Access

[Christopher]

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?

 

[Les Mercer]

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?

 

[Graham Mayor]

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.

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

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