How to move decimal place for percentage

[Dave H]

On a from I am creating I want to make it user friendly. They enter an amount for a percentage. I have the format set to percentage. If you type in 99 you get 9900% instead of 99%. Is there an easy way to correct this?

Thanks

 

[Rickster57]

One way to skin this cat (and there are a few more) is......

In the After Update Property of that text box (if it's name is mypercentage) put me.mypercentage=me.mypercentage/100.

Make sure that in the table you are using that the Data Type is set to Number AND the Field Size is set to single.

 

[Dave H]

I am new at this and I am a little confused. On the table where the data will go it is set to number and single. My field on the form is called text73. On the text box properties on event after update I typed me.[text73]=me.[text73]/100

I then get an error that it can't find the macro me. I am assuming this should be an expression and my syntax is not correct. Can you clarify for me.


Thanks for your help.

 

[Rickster57]

In the After Update field of the text box click in that field. To the right you will see a dropdown box arrow. Click on that and choose Event Procedure. Then type in the code I mentioned above.

If you try to enter that code just in the field it thinks there is a macro with that name.

Good luck

 

[Dave H]

That did exactly what I wanted.

Thanks