Problem with calculated fields in mail merge

  • Thread starter Thread starter carlos
  • Start date Start date
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
 
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")
 
Back
Top