That may seem like Captain Obvious speaking, but you'll be amazed at some of the data that gets entered into a name field. I then created an If statement to determine how the input data was formatted and whether or not the data is only alphabetic.
Sometimes people are just trying to be funny, or they are literally trying to break your program. If the data is indeed only alphabetic letters (no symbols, no numbers or any other punctuation characters) the test succeeds and stores True inside the Name Valid variable. This is because it becomes more legible than just a normal set of numbers.
Regex class for validate any input string for any specific format.
I have even tried using the code as below but it does not help If Is Date(Format(txt Text Box.
Based on each of these variables' values, we will know if the data is correct or not. The Leave event fires when the control loses focus. As you can see, Regular Expressions are a vital tool to have at your disposal, so become good friends with them.