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 ?