Percentages in Access

  • Thread starter Thread starter EL
  • Start date Start date
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?
 
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
 
It sounds like your field is an integer which can not store decimal
information. Change it to Single or Double.
 
Back
Top