Trailing Zeroes Stripped from Currency Field in Word Mail Merge from Access

[Lorna Olsen]

A field in my table has the Currency format. Trailing
zeroes to the right of the decimal point display fine in
Access (2002 and 2003) and export great to an Excel
workbook; however, when I perform a mail merge with this
data to a Word document the trailing zeroes are stripped
out, like this:

15.50 in the Access table, is 15.5 in the Word merge doc.

Can anyone help? Thanks in advance!
Lorna

 

[Douglas J. Steele]

You could create a query that wraps a function around the field, and use the
query instead of the table directly.