Percentage values on a form

[mikemaki]

This is a very minor problem. But it's one of those things that will bug me to no end. I have a discount field on a pop up form whose format is set to percentage. The field it is bound to is also set to percentage. When the user entered, for example, 50, the field would change to 5000%. So in the AfterUpdate I divide the value by 100. This works fine. The issue that's got me stumped is the appearance of the value. When the value is 50.00% and the text box receives focus, the appearance stays 50.00%. When the value is 10.00% the appearance changes to 0.1. I've entered various values and some change and some don't. Would anyone know why?

 

[reclusivemonkey]

50 is 5000%. 50% is 0.5. Don't change this with calculations, simply write validation rules to make sure your users enter correct values. Do you ever want them to be enter over 100%? If not, simply set the validation to accecpt <=1.