how do I make a currency number retain the 'cents' figure?

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

Guest

when I enter 5.58 into a form it rounds the cents to the next dollar amount.
I've tried changing the format using 'standard', 'fixed' and 'currency'; i
have my decimel place at '2' but nothing seems to help
 
There is the format on the form, which it sounds like you are
modifying. But what type of field is it in the Table itself.

It sounds as if it is an integer, and the datatype should be currancy
or number and then the format as single or double or fixed with decimal
and a few other combinations.

But it can NOT be integer anywhere along the line.

Ron
 
Back
Top