Percentages in Access

E

EL

In my form, I have entered a field where percentages must be entered.
However, when I enter 0.5, the value changes to 0. If I enter 1, it displays
as 100% which is fine but I am unable to figure out how to enter 0.5%.

How do I fix this?
 
S

scott04

EL when you go into design view what setting do you have it as format? Also
you may want to check the decimal places field for the textbox as that may be
sent to 0. You may want to set decimal to 1 or 2
 
R

ruralguy via AccessMonster.com

It sounds like your field is an integer which can not store decimal
information. Change it to Single or Double.
 
Top