Printing merged currency fields in word documents

[Dan Beck]

Hi

I'n new to word and access.

I am trying to do a mail merge into a stock letter from
an access query. Name, address, payment amount etc.

Everything works well except one currency field.

What I want to see is $123.90

What I get on the letter is 123.9

The field displays fine in access.

Any suggestions?

Dan Beck

 

[Dan Beck]

Graham

I tried the format you suggested from your website.

I used the information from your website and formatted my
field as shown below:

{ MERGEFIELD «Total_Due_2003» }
{ MERGEFIELD «Total_Due_2003» \# ",$#.00;(,$#.00)"}

This is the result:

This is a reminder that your Annual Homeowner Dues are in
arrears in the total amount of
{ MERGEFIELD 12.5 }
{ MERGEFIELD 12.5 \# ",$#.00;(,$#.00)"}

I'm probably doing it wrong.

Any suggestions?

Dan Beck

 

[Andrew]

Need to use a DDE link when it asks you to select Data
Source during the Mail Merge Wizard.. If the Select Data
source does not appear the go to Tools,Options, General
and make sure Confirm Conversion on opening is selected.

 

[Graham Mayor]

That would work also, but for this particular issue, the switch is simpler.
Date fields - particularly US/UK dates - are another matter

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>