Too many decimal places in mail merge

[mura]

I have an Access database that is used as the Data Source in a mail merge document in Word. I use a Number field which I've set up as follows:
Field Size = Single
Format = Fixed
Decimal Places = 2

When I use that field in a mail merge document, I get 7 or more decimal places -- even after simply putting in a number with two decimal places.

The same is happening with Currency fields I've set up. Any clues?

Thank you for your assistance.

 

[chrismcbride]

I know for sure that currency fields actually hold 4 decimal places and are only FORMATTED to show you the first two. I suspect that the same is true for the Single, Fixed, 2 Decimal place column that you describe. In order to get rid of the extra decimal places, you can cast using CLng. Do a bit of experimenting with this. You can apply the cast when doing your merge, but it might be better to do it when the values are initially saved to the table.

I use this in some of the Import functions that I use to get values from price lists that are given to me by my suppliers, because their Excel sheets have the same hidden decimal places.

CLng(unit_price * 100)/100

HTH
Chris