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.
 

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

Top