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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Format Currency 2
Access Form Refresh 1
Currency format won't show in form 4
Rounding in a Currency Field 4
Currency Decimals 5
Excel Excel 2007 won't stop rounding down my formula results! 5
Looking for a good currency textbox control 2

Back
Top