HI I have a userform with a textbox that will not let you exit it if it is empty. This works great until I want to exit the userform and click a command button to leave and it asks me to enter a batch no.
I found a old post suggesting the following
However this does not seem to work for me even though the logic seems fine. Am I missing something or is there alternative ways around this problem.
Please Login or Register to view this content.
The problem is that when you try to click the button, the Exit event on the textbox takes precedence and you never get the button Click event. So the textbox complains that it's still blank.
I can think of very few cases where you want to use an Exit event to force the user to provide a value. I would redesign the user interface so that you are not checking the content of the textbox until you try to exit the form. Then check for an empty textbox at that point.
I guess this could solve your problem:
And yes, you shouldn't use the exit-event for validation purposes. Consider the before_update or after_update events.Please Login or Register to view this content.
Last edited by Tsjallie; 10-18-2013 at 09:28 AM.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Did you set the TakeFocusOnClick property of the button to False?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks