Hi James,
try saving the inputmask in the gotfocus() of the textbox, set it to "9999999" or whatever and then set it back to what it was initially in the lostfocus().
>Hmmm, that doesn't work either ... I wonder if I've got something else set somewhere that's affecting this. In the meantime, however, I've just removed the inputmask altogether, which isn't as functional, but at least it works.
>
>Thanks
>
>>PMFJI
>>
>>[1] Format = "R", ImputMask "9,999,999"
>>[2] Nothing at all
>>[3] My guess, no, but try it anyway (I don't remember)
>>
>>HTH
>>
>>
>Could you be a little more specific?
>>
>>>I guess I should have been as well, as I didn't indicate that I removed the default textbox and added my own. So my questions include:
>>
>>>[1] What do I set the inputmask and format for the column?
>>>[2] What do I set the inputmask and format for my textbox?
>>>[3] Does the setting of sparse=.f. affect this somehow?
>>
>>>Thanks
>>
>>>Hi James R,
>>>I believe you'll get what you want if you set the Format property to R.
>>>
>>>>Something easy I'm missing here ...
>>>>
>>>>I have a numeric column in a grid. I'd like the values to display using a value for inputmask of '9,999,999'.
>>>>
>>>>However, the user can modify the data in this column, and the inputmask really screws things up when the user tries using the keyboard.
>>>>
>>>>So, I'll looking for the way to set the inputmask so that it applies for each row, unless the user is editing the value, in which case I want to discard the inputmask. Somehow, this seems related to "sparse" (which is .F. is my example)?
>>>>
>>>>Thanks