Field rounding

[reburton]

I have a field in a table that keeps rounding the data entry off. It has identical properties to the field next to it but one rounds and the other does not. I tried deleting the field and creating a new one. I tried renaming it. I am sure it is just something I don't know about access but I am at a dead end.

 

[pr2-eugin]

Have you checked all the properties in both fields? Are they identical? Including but not limited to Decimal Places, Type, Input Mask?

 

[reburton]

Yes, identical in every way. And to make it worse, in a calculated field it uses the rounded off number to multiply with another rounded field, compounding the error.

 

[reburton]

I Just discovered that all of my numeric fields in this table are behaving in similar fashion. I don't know how I missed that.

 

[pr2-eugin]

Calculated Field or Calculated Control?

 

[reburton]

Thanks to all who responded to my post! Something someone said triggered something in the back of my mind which led me to the solution. I was under the mistaken opinion that Access performed some kind of magic with integers so they could be used as decimal numbers. I am really confused about why Access permits integers to be displayed with a decimal point. Anyway I simply changed my number type to single and my problem was solved. Thanks again!