Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010
    Posts
    1

    Cool Unanswered: Help regarding input masks validation etc...

    Hi,

    Thanks in advance for the help. i'm creating a database on Microsoft Access 2007 for my A2 coursework at college. I have made a data capture form with name adress etc. But my email address input mask isn't working that my teacher told me to put in. My validartion rule is a Format Check with the input mask being Like(*@*.*). Is this right? I don't have a clue as it's not working and I know its wrong but my ICT teacher won't help me!

    Sorry if its a little long and confusing only just coming to grips with Access

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    The official standard is known as RFC 2822. It describes the syntax that valid email addresses must adhere to. You can implement it with this regular expression:
    Code:
    (?:[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*|"(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21\x23-\x5b\x5d-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])*")@(?:(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?|\[(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|[a-z0-9-]*[a-z0-9]:(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21-\x5a\x53-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])+)\])
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •