Access Table

S

Simon One

Can someone please confirm the Field property in a table for fixing the
STORED value of a curreny value to 2 decimal places.

Many thanks

Simon
 
P

Pat Hartman \(MVP\)

There is no property that controls the number of decimal digits STORED for
the Currency data type. The DecimalPlaces property defines what is
DISPLAYED. Try using the Decimal data type. I think it may allow you to
define the digits stored.
 
Top