How can I cancel automatic rounding of numbers in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Jess said:
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.
Click to expand...


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.
 
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.
 
Back
Top