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: [email protected]
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")
 
Top