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

M

Muhammad

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.
 
D

Douglas J. Steele

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