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. You could say that a program's testers are supposed to do this; yes, they should - nobody else should. If not, if there is even just one unallowed character that is not supposed to be there, the Match method will return False. Instead of you having to loop through each character to determine what that character is, you simply need the correct Regular Expression pattern. Clear() Surname Valid = False Else Surname Valid = True End If End Sub It is basically the exact same code for the Name box, but I just included the capability to comprehend a space character as well. People expect to enter a phone number in a format similar to this: ###-###-####. Another thing I like to do is to display the validation error message on the form in an otherwise hidden field: The problem with our last solution is that if the user saves a partially filled form, and picks it up at a later time, that error message that popped up is long gone, and the only indication that there is something wrong with the form is the modified field color.So, having a text field contain that error message might be a good idea. This means that as a programmer, you have the power to supply the exact pattern for the input you desire in any text input field. Again, certain special characters are obviously not allowed. They make use of a pattern matching system to match the input with a certain pattern of data.
My surname contains a space and it can get quite frustrating if I am not allowed to enter my correct surname, or that I have to edit my surname not to include a space. In certain cases the international dialling code will also need to be supplied. Compiled _ ) Dim bln Possible Match As Boolean = re Email. Text) If bln Possible Match Then 'Check If Entered Email Is In Correct Format If Not txt Email. Latest Bank Statements for last 6 months (in case of First Time Borrower) and 12 months (in case of Takeover proposals).In case of multiple banking, statements covering minimum 75% of banking turnover is to be provided.To start, we create a text field and bring up the properties dialog for the field.Then we select the “Validate” tab to see the validation options: The default is that the field will not get validated.