Problem with calculated fields in mail merge

C

carlos

Dear all,
I have to do a mail merging from an Access query to MSWord,
and I have problems with a calculated field (a percentage).
Regardless of specifying in the field properties the format
and (fixed) and number of decimals (2), when the field is
merged in Word, it has a lot of decimals. It looks like the
format has not been retained.
Any suggestions are welcome!
If possible, answer also to my email: (e-mail address removed)
Thanks in advance
 
V

Van T. Dinh

Don't use the Format Property as this only affects the display, not what is
being passed to Word.

Use the Format() function as part of your calculated expression like:

FormatForWord: Format({CurrentExpression}, "0.00")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top