Remove automatic rounding of number fields

[Colleen]

I have an Access 2003 database with several number fields. The fields are
large integer with two decimal places. When data is entered the field
automatically gets rounded. How can I remove this option. I have never had
this problem in the past.

 

[Rick B]

An integer (by definition) has NO decimal places. An integer is a whole
number.

Change your field to an appropriate "Filed Size" in your table. Single or
Double would be more appropriate.

Single Stores numbers from -3.402823E38 to -1.401298E-45 for negative values
and from 1.401298E-45 to 3.402823E38 for positive values.

Double Stores numbers from -1.79769313486231E308 to -4.94065645841247E-324
for negative values and from 4.94065645841247E-324 to 1.79769313486231E308
for positive values.

 

[Duane Hookom]

Change the field types to one that stores decimal values: Double, Single,
Decimal, Currency...

 

[Tim Ferguson]

The fields are
large integer with two decimal places.

Integers don't have any decimal places: that's what makes them integers.

Change the data type to Double or Single or Currency (that's in the field
size box, for reasons best known to the Access design team).

Hope that helps


Tim F

 

[Pat Hartman\(MVP\)]

As everyone has already mentioned, integers by definition do not have
decimals. As long as you need only two decimal places of precision, I would
recommend using the currency data type. It is not subject to the "rounding
errors" that you will run into with the single and double precision data
types.