>>>Nadya,
>>>
>>>Thanks, but the situation is quite different. Your case was that you wanted an unbound TextBox, I want a
bound textbox, but, even though it is bound to a Character field, I would rather have standard numeric input.
>>>
>>>Since all the workarounds seem to be fairly complicated, I will just change it to an unbound TextBox.
>>>
>>>Hilmar.
>>
>>I was just reviewing this thread again. I want to be able to insert the number in the numeric field, so if it was, say,
>>
>>4790.25 and I put the cursor at the 0 and type 1 I want it to become 47910.25 and not 4791.25 as it does currently.
>
>If you insist on numeric value (character should work fine) then you may check Textbox.Selstart property in Textbox.KeyPress event and recalculate textbox.Value according to your request.
I was just thinking that I would have to use character, e.g. unbind in gotfocus, let the user type, then replace in lostfocus, but wanted to double check first with numeric textbox without controlsource - I suspect it would still behave incorrectly.
If it's not broken, fix it until it is.
My Blog