(Solved) – Force user to write name, not numbers [closed]

  • by

I have this interface:


As you can see, there are text fields, and I would like to impose certain conditions, for example the “nom de la sté” must be in character, ie if someone writes in the field “nom de la sté” 123456 it must display an error and do not add 123456 to the base, concerning the display of the warning I did well with this code:

If Me.TextBox1.Value = "" Or IsNumeric(Me.TextBox1.Value) 
Then MsgBox "enter a name", vbCritical 
End If

same thing with email, I want to force the use to tape @ and .com or .fr

Leave a Reply

Your email address will not be published. Required fields are marked *