Decimal rounding instead of displaying

[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!!!

 

[Guest]

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

 

[fredg]

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!!!

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.

 

[Heidi]

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!

 

[Allen Browne]

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.