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
 

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

Top