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

N

NanO

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
 
R

Ron2006

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
 
Top