Access Email Input mask.

[Emeka Nwosu]

Hey,
Please can I get the format of an input mask that would validate email
addresses in a Access table?thanks

--
Emeka Nwosu
Phone+234) 01-8143183
Message+234)802317154
My weblog = http://randomscribblesbyemeka.blogspot.com/
Where I work = http://www.sphinx-interactive.com

 

[John Vinson]

Hey,
Please can I get the format of an input mask that would validate email
addresses in a Access table?thanks

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)

 

[Emeka Nwosu]

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?

 

[John Vinson]

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?

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)