Mail Merge Format

[PJFry]

I have a merge field for interest rates that is not formating correctly. The data is pulled via mail merge from access (both word and access are 2002). The interest rate comes across like 14.89999999999999%. In the data base it is stored as 14.99%. I have tried many variations of the field codes, but I cannot find on that works. Any suggestions?

PJ

 

[CautionMP]

If the mail merge is based on a query in the database you can change the interest rate field to a string and then populate the value using the Format() command. This will give you complete control of the data format in Access, before Word ever gets to see the data.

P.S. The field format in Access is probably hiding the all the decimals when you look at the rate in Access but Word is seeing the whole field when you merge. If you want to truely truncate the interest rate in the database set the field data type to decimal with a precision of 4.