Formatting currency decimal

D

David R

Access 02

In a form, currency field, I would like to enter a number such as 4567 and
get $45.67. What I get is $4567.00. I have tried using an input mask to no
avail.
Anyone know how to do this?

David
 
R

Resti M. Guay

the value you entered is not a decimal number and table will store only what
you have typed and inputmask can't do about the value you entered.
hope this will help

resti
 
E

Ed Robichaud

You need to change the field data type to "currency", then the two rightmost
digits will be treated as cents.
-Ed
 
Top