Ensure TextBoxes are Filled in VBA Forms

Hi all,

This is an extension of here. What I am trying to now accomplish is making sure all fields are filled out before the form unloads. I have the following code, thanks to the mentioned link:

Please Login or Register  to view this content.

**Note** Yes I used a GoTo, but only to try it, I swear I didn't inhale
At any rate, the GoTo went on a continuous loop so it was useless to me anyways. The main point is, I don't want the form to unload until all of the forms are filled. Thoughts?

Thank you.

You could use something like

Please Login or Register  to view this content.

Thank you mikerickson, that was exactly what I was after.

You can't set focus on more than 1 item.
I'd prefer not to indicate whenever a user does anything 'wrong' (the user never does), but to indicate when the user's input suffices by showing a next field or a button to continue.

That code is not setting the focus to more than one control, just to the last one that failed the test.

I agree, its a better user interface that prevents the user from making bad entries than one that corrects them after the fact. Nonetheless, the OP is following the many (bad) examples set by what is out there.

Thanks for all of the input. Your code worked like a charm mikerickson.