Zero decimal getting dropped.

[Guest]

I produce a report with a number to 3 decimal places. If the last decimal
place is a zero it drops it and only prints two decimal places. This makes
the whole column look jagged. I put in Properties, Decimal Places 3, but it
still drops it. What to do?

Thanks.

 

[ruralguy via AccessMonster.com]

Use the Format() function to turn it into a string value with three decimals.
Leading and trailing zeros in a numeric field make no sense and as such are
dropped.