display fixed number

A

accessfun

I have a table column named RATE as CURRENCY and set up as double, auto
decimal. I input number 1.4931. After save it, I change to decimal = 2. It
display as:
1.49 but once you click this cell, it displays 1.4931. How to make this
column display only 2 decimal for ever?
 
K

Ken Snell [MVP]

You'll need to prohibit the entry of more than 2 decimal places. You could
use an input mask to do this, or you could use programming in the form that
is used for data entry to round to two decimal places before writing the
data to the table.
 
Top