How can I cancel automatic rounding of numbers in Access?

[Guest]

I selected all pre-define formats in access 2007 but when I enter the
figures, still it round off the decimals to the nearest number. I want my
data to be the same as to my entry.

 

[Brendan Reynolds]

I selected all pre-define formats in access 2007 but when I enter the
figures, still it round off the decimals to the nearest number. I want my
data to be the same as to my entry.

Open your table in design view and select the field, then check the 'Field
Size' property in the lower part of the screen. It is probably set to
Integer or Long Integer. Try changing it to Double.

 

[RBear3]

What kind of field are you using? If you are using an Integer, then by
definition it will only accept whole numbers. Change the "Field Size" in
your table to a format that supports number that are more precise than whole
numbers.