>> Iteresting idea. I will remember this one. Though KeyPress should do the work too...
>
>I like this method because if they type anything at all in the textbox then my code will always fire (and if they don't type anything it never does). I have some users who refuse to use Enter or Tab to move between fields (they just love that mouse!) and if you put your code in the KeyPress, you're just out of luck :)
Actually, we can still put the same logic in Valid (or in LostFocus event), and check oldval(). But I also like your idea. I've just written the code using valid and oldval (it's because I'm using Grid). Will see, how it works, and if it would not, I'll try your idea...
Thanks again.
If it's not broken, fix it until it is.
My Blog