Getting "2%" from entering just "2"

[outsourceoncall]

What do I need to do to get a form field or a table field to allow easier data entry for percentages? For instance, if the value should be 2%, the user wants to jsut type "2".

I know this is a stupid question....

 

[THoey]

Why not just divide the enter value by 100? Make sure to test for zero... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[scriverb]

Set the format property to Percent. Set the Decimals property to 0. Finally, put this code in the After Update event procedure of the control:
me.controlname = Me.[controlname]/100

That should do it. Bob Scriver

 

[outsourceoncall]

Duuuuuhhhhhhhhhh, someone please delete this question...

Thanks!