How can I format a percent without it multiplying by 100?

  • Thread starter Thread starter Guest
  • Start date Start date
The problem with that is, if the user enters "15" (wanting 15%), she gets
"1500%" in the box formatted as Percent. It's difficult to train users to
put "0.15" in a field when they want "15%".

I usually just leave the format alone and put a "%" sign in a label after
the box.

Carl Rapson
 
You must log in or register to reply here.

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

How to Populate Data from a table to another 0
Percent Formats 1
Percent Field 3
Percent value rounds up in Access 1
Convert Single to Percent 4
how do I change format to percentage without multiplying by 100 5
Access Test if value is less than percent 0
Conditional Function 4

Back
Top