Printing merged currency fields in word documents

D

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
 
D

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
 
A

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.
 
Top