Posted on 2008-06-19
I put an unbound field on the screen into which the user will enter a percent. The percentage entered can have up to 3 significant digits. Simple, right?
I put the text box on the screen and set the Format property to 'Percent'. Initially I had the decimal places set to 3 and later changed it to 'Auto' but the behavior was the same in each case.
The issue is that I can't enter decimals. it is quite possible that the percentage entered into this field will be something like 1.125 but when I enter 1.125 it shows as 112.50%. My users are easily confused and I', sure they won't understand this.
I can set the property to 'Fixed' and decimals to 3. That way when the user enters 1.125 that is what is displayed. However, I thought it would be a nice touch and make the fiedl more intuitive if I showed the % sign.
Is there a way to set up a field with format 'Percent' such that when 1.125 is entered it shows as 1.125% (without any code manipulations for example: divide by 1000, behind the scenes)