Data entry field formatted for percent

[Scoob55k]

I have a field on a form where I am trying to enter a number that would be recorded as a percentage. In my table I have the field formatted as a percent. However, when I put in 25, for example, in my form, it records as 2500% instead of 25%.

Seems like a no-brainer, but I can't figure it out.

Any help? Thanks!

 

[JoeAtWork]

Formatting as "Percent" assumes the number is a decimal. E.g. if the number is .25, it would be presented as 25%.

 

[Scoob55k]

Thanks for the response. Do you know how to correct this so the user only has to put in a whole number?

 

[Scoob55k]

I tried some code that AfterUpdate for that field it took the whole number in the field, divided it by 100, and reinserted the decimal # in the field. Didn't work, but I think its the syntax not the idea that's hurting me here. Take a look:

Dim Calculation

Calculation = ([PercentCancelled] / 100)
PercentCancelled = Calculation

Should be fairly simple I figure. This code does something as it takes the number I put in there, say 50, and returns a 0 which becomes 0% of course. Thanks!!