changing the number format of percent field

[ISTodd]

Hi,
Is there an expression (or something easier) to change the format of a percent in a table and on a form or report? when I add "75" into a percent field it reads 7500% I want it to read 75%.

Thanks for any elp on this... Todd

 

[txaccess]

In the Before Update Event of the field type:

me.<YourFieldName) = me.<YourFieldName)/100

This gives you the correct percentage

Hope this helps

I haven't failed, I have just found 10,000 ways that it won't work!