In Access Form how do I stop figures from rounding up?

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

Guest

I am working on an Access Form, I have a 'numeric' field in it, when I put
some value in it e.g. 10.5, it automatically rounds up to 11. I have tried
adjusting field properties but could not succeed.
 
What's the Field Size of the numeric field in the underlying table? When you
set a field's Data Type to Numeric, Access defaults it to Long Integer
(which can't store any decimal points). You need to change that to Single or
Double in order to be able to store decimal points.
 
Back
Top