Inputting percentages in forms

A

Amy B

I have a form where the user needs to enter a percentage. Currently it's
formatted as a a percentage, so if the value needs to be 10% the user has to
enter 0.1. Is there any way I can format that field so the user can input 10
and have it be 10%??
 
A

Al Campagna

Amy,
Use the AfterUpdate event of that field to run the following code...

Private Sub YourPctField_AfterUpdate()
YourPctField = YourPctField / 100
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 

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

Shortcuts in OneDrive 0
Space at end of multi page list to accommodate new entries 1
Sharepoint not capturing staff name when automation runs 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Forms offline? 1
Doughnut Chart linked with the slicer in the pivot table 0
Word OLE to check spelling in text box 1

Top