Formatting currency decimal

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

Guest

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
 
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
 
You need to change the field data type to "currency", then the two rightmost
digits will be treated as cents.
-Ed
 
Back
Top