>>>>Hi everyone,
>>>>
>>>>I have a form DataDict with IndexExpr field as an EditBox (memo field). I want
>>>>to convert the entry in this field (EditBox) to:
>>>>1) Upper case
>>>>2) Replace <> or != with #
>>>>3) Replace single quote or [] with double quote.
>>>>
>>>>What's the best EditBox method/event to achieve this functionality?
>>>>
>>>>Thanks a lot in advance.
>>>
>>>Lostfocus ? But are you sure you want to do it for option 3.
>>>Cetin
>>
>>Yes, I thought about LostFocus too. Great minds... you know :)
>>And I can not be 100% about option 3, though in my application and the usage of IndexExpr I believe, can be. It would be very unlikely, that user want an Index expression like:
>>index on "Nadya's + Cetin's work [could ]+upper(fieldname)+' not be done'" :)
>
>Actually I noticed DataDict and IndexExpr after I clicked 'send' :) Why don't you just normalize() and leave rest as is.
>Cetin
This code could not be placed in InteractiveChange, as I just found, only in LostFocus. And it works great in LostFocus. Thanks again for the idea.
If it's not broken, fix it until it is.
My Blog