How to create an input mask for e-mails

[Guest]

Hi. I want to create an input mask for e-mails in order to force people to
insert the @ and the . (dot).

Any one can help me?

Marco Silva.

 

[John Vinson]

Hi. I want to create an input mask for e-mails in order to force people to
insert the @ and the . (dot).

Any one can help me?

Marco Silva.

Input masks are not sophisticated enough to do this. Email addresses
are simply too diverse.

Instead, use a Form to do the data entry, and use the textbox's
BeforeUpdate event to (roughly) check for validity. For example, you
could use

Private Sub txtEmail_BeforeUpdate(Cancel as Integer)
If Me!txtEmail & "" = "" Then Exit Sub ' ignore blank emails
If InStr(Me!txtEmail, ".") = 0 Then
Msgbox "Invalid email - must contain a period"
Cancel = True
End If
If InStr(Me!txtEmail, "@") = 0 Then
MsgBox "Invalid email - must contain an @ symbol"
Cancel = True
End If
End Sub

John W. Vinson[MVP]

 

[Guest]

Thanks, worksperfectly.

Regards,
Marco

Input masks are not sophisticated enough to do this. Email addresses
are simply too diverse.

Instead, use a Form to do the data entry, and use the textbox's
BeforeUpdate event to (roughly) check for validity. For example, you
could use

Private Sub txtEmail_BeforeUpdate(Cancel as Integer)
If Me!txtEmail & "" = "" Then Exit Sub ' ignore blank emails
If InStr(Me!txtEmail, ".") = 0 Then
Msgbox "Invalid email - must contain a period"
Cancel = True
End If
If InStr(Me!txtEmail, "@") = 0 Then
MsgBox "Invalid email - must contain an @ symbol"
Cancel = True
End If
End Sub

John W. Vinson[MVP]

 

[Guest]

Hi again,

I don't if you ever checked but if your e-mail has a dot it doesn't control.
In i.e. if the e-mail is: (e-mail address removed) if I write
marco.silva@hotmailcom it doesn't check for erros because there is a dot in
the e-mail.

I just think you would like know.

Marco.

 

[John Vinson]

Hi again,

I don't if you ever checked but if your e-mail has a dot it doesn't control.
In i.e. if the e-mail is: (e-mail address removed) if I write
marco.silva@hotmailcom it doesn't check for erros because there is a dot in
the e-mail.

I just think you would like know.

I did know... thanks.

This is a VERY simple, limited example. I'm sure someone somewhere has
written a VBA routine to check for well-formed EMail strings; if so,
it is certainly long, complex, and tricky. My example was not intended
to be such.

John W. Vinson[MVP]