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

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


    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
    Provided Answers: 15
    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:
    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