General information
Category:
Forms & Form designer
Title:
Entry of formatted numeric data in text boxes
I frequently need to set the inputmask property of a textbox (or the surrogate that is the default for grid cells) to something like '9999,999,999.99'. Piece of cake. But, when the field bound to the control already has a value, say, 123.44, and the user wants to change it to, say, 12.01, he ends up with a value of something like 12123.00.
We first noticed this in our accounting application, with fast typing users. We tried with setting CONFIRM on or off, tabbing out of the field, pressing enter after the data has been entered, with insert mode on or off, using the K option of the format property, etc.
Even with no inputmask, this happens. It is distressing to waste so much time with a trivial issue like this.
BTW. The bound field is numeric.
Before this, we had to convince our customers to accept the comma as the number separator and the period as the decimal point. In this country the opposite is the convention. This mask '999.999.999,99' makes incredible fuss when trying to enter the decimals.
Any help ?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only