Access Email Input mask.

  • Thread starter Thread starter Emeka Nwosu
  • Start date Start date
Hey,
Please can I get the format of an input mask that would validate email
addresses in a Access table?thanks
Click to expand...

No, you cannot; input masks are much too inflexible to handle the vast
variety of valid EMail addresses.

You'll need to use VBA code in the BeforeUpdate event of the form
textbox - and if you're trying to do it in a table datasheet, I cannot
think of any good way to do it (since table datasheets don't have
programmable events).

John W. Vinson[MVP]
(no longer chatting for now)
 
Thanks.Any means by which I can prevent people adding invalid characters is
good with me.Could you possibly help out with a few lines of code for the
BeforeUpdate event?
 
Thanks.Any means by which I can prevent people adding invalid characters is
good with me.Could you possibly help out with a few lines of code for the
BeforeUpdate event?
Click to expand...

Sure. Try something like:

Private Sub txtEmail_BeforeUpdate(Cancel as Integer)
If Me!txtEmail Like "*[ !$%^&*()]*" Then
MsgBox "Invalid characters in EMail address", vbOKOnly
Cancel = True
End If
If Me!txtEmail Not Like "*@*.*" Then
MsgBox "EMail should be in the format (e-mail address removed)", vbOKOnly
Cancel = True
End If
End Sub

Use a verified (rather than my guess!) list of invalid characters
inside the brackets in the first IF.

John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top