Force SetFocus until input has been made

[onmyway]

Hi guys,

I have this code that checks that my TextBox is not empty, and also formats it. But when one tabs through the field, a warning does pop up, but the cursor moves to the next field. How can I change/force the focus to that field until an input has been made?

i have tried SetFocus

Here is my code:

Please Login or Register  to view this content.

Thank you!

[Leith Ross]

Hello onmyway,

This where the argument Cancel becomes your friend. Setting Cancel to True prevents the focus from moving to the next control in the tab order.

Please Login or Register  to view this content.

[MarvinP]

Hi onmyway,

Have you tried a SendKeys to do a shift tab to get back to the prior input box?

See https://msdn.microsoft.com/en-us/lib...ffice.15).aspx

I normally use a DoEvents in my code with SendKeys to insure they are received and processed correctly.

[Arkadi]

Onmyway,

Was about to answer, but Leith beat me to it, glad I did a refresh. The problem with your code was that your exit code runs, THEN exits. So technically the box still had focus. Weird, but basically a timing thing. As Leith said that is when cancel becomes your friend

[onmyway]

Hi all, great answers. Thanks a lot!

[onmyway]

May I ask one more thing in this thread: what line of code can i add that will warn the user that the field may not be blank when tabbing through the field?

[onmyway]

I did the following: is that OK?

Please Login or Register  to view this content.