|
| 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
March 4th, 2008, 04:09 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
March 4th, 2008, 05:51 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
