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.

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.

Phil wrote:
>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.

-- 
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200703/1