Decimal rounding instead of displaying

  • Thread starter Thread starter Heidi
  • Start date Start date
H

Heidi

No matter what I do in the form, the decimal point rounds
to a full 1. EG: I try to enter 25.94 (or any decimal
point) and it rounds to the nearest whole number, in this
case, 26, of course. I have tried to make it so that
there are manually 2 decimal places and it still rounds
it. I'm still trying to figure out how to make it not
round off, so in the meantime...Does anyone know how to
fix this?? Thanks!!!
 
Is your form looking at values from a table? If so, I
think you have to control format at the table end. Check
the format for the field in the table itself. If the
table specifies integer or byte or fixed with 0 decimal
places, you'll have to change the number type to single or
double to get decimal places.

Hope this helps
 
No matter what I do in the form, the decimal point rounds
to a full 1. EG: I try to enter 25.94 (or any decimal
point) and it rounds to the nearest whole number, in this
case, 26, of course. I have tried to make it so that
there are manually 2 decimal places and it still rounds
it. I'm still trying to figure out how to make it not
round off, so in the meantime...Does anyone know how to
fix this?? Thanks!!!
Click to expand...

You probably have the Field's Number size property set to Long integer
or Integer.
By definition, an integer is a whole number.
Change the field size to Currency, Double, or Single.
 
It is not allowing decimals in the table, not just the
form... I found a little bit ago that if I change the
format in the table to Decimal it works, but is that
going to pose a problem as opposed to the Single or
Double? Thanks!
 
Yes, it will cause problems, Heidi.

The Decimal type is not properly implemented in Access, and is very buggy.
It does not even sort correctly. Details:
http://members.iinet.net.au/~allenbrowne/bug-08.html

As fredg said, use a Double if you want the flexibility of a floating-poing
number, or a Currency if you want the precision of a fixed point number and
no more than 4 decimal places.
 
Back
Top