Inputting percentages in forms

[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%??

 

[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."