why is my currency is rounding off.

  • Thread starter Thread starter kelly draper via AccessMonster.com
  • Start date Start date
K

kelly draper via AccessMonster.com

I have a textbox formatted as currency. the field that it is bound to is
also formatted as currency in it's table.
problem is, I cant input any cents into the textbox. when I enter dollars
and cents, the textbox automatically rounds to the nearest dollar. Anybody
know why it's doing that and how to make it stop cuz this problem just
doesnt make any cents (Ha!Ha! bad pun.)
 
Have you checked the "decimal places" property in the table and in the
form's control? One of them might be set to zero.
 
I have a textbox formatted as currency. the field that it is bound to is
also formatted as currency in it's table.
problem is, I cant input any cents into the textbox. when I enter dollars
and cents, the textbox automatically rounds to the nearest dollar. Anybody
know why it's doing that and how to make it stop cuz this problem just
doesnt make any cents (Ha!Ha! bad pun.)
Click to expand...

I strongly suspect that your Table definition has this field as a
Number; the default Number datatype is a Long Integer, which is an
integer - that is, a whole number without decimals.

Change it to a Currency datatype (not the format, but the *datatype* -
it's on the list along with Number, Text, Date/Time and so on).

John W. Vinson[MVP]
 
Back
Top