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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Small textbox width forces rounding. 5
How do I stop Access rounding up the figures I enter in to a form 3
rounding problems 11
stop rounding of figures in a sub-form 1
Don't want Access to round numbers to nearest integer. 1
Form Combo incorrectly rounding 1
Rounding decimal values in forms and reports 2
rounding values in Access 4

Top