Force The User To Enter Valid Value In Text Box

Using the Validate event, you can assure that the user will enter valid value in the text box. "Valid Value" can be anything you define: Phone Number, date, number in certain range, certain strings, and so.
Until he done so, all the other controls are disabled, and he cannot exit the text box.
In this example, the user will not be able to exit the first Text Box, until he type "abc".
To check this code, try to press the button or enter to the second text box.


Add 1 Command Button and two Text Boxes to your form.

Form Code

Private Sub Text1_Validate(Cancel As Boolean)
      Cancel = Text1.Text <> "abc"
End Sub

Go Back