If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inputting percentages in forms
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%?? |
#2
|
|||
|
|||
Inputting percentages in forms
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." "Amy B" wrote in message ... 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%?? |
Thread Tools | |
Display Modes | |
|
|