I set up a field on a form for users to enter a discount %.
The plan was that they would type "25", it would display as "25%" and then another field would calculate the $ amount of the discount.
However, the % field isn't working as I anticipated.
If I type in "25", it displays "2,500%"
The $ amt field calculation works fine...its just the display that isn't doing what I want it to.
I've tried playing with the patterns and, no matter what I do, I get the same result.
Excel sort of works the same way and uses an assumed decimal place after the last digit if none is entered.
If you want to write all of the necessary code for the adjustment, be my guest.
George Kaiser