display fixed number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top