Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Data Validation Rules 2. Enter the Expression: LIKE "[A-Z]*@[A-Z].com" OR "[A-Z]*@[A-Z].net" OR "[A-Z]*@[A-Z].org"   LIKE " " looks for something like whatever you type between the quotes.   The Wildcard * means the email address can begin with any letter from A-Z   Or Like adds another criteria. In this example, the code compares three domains: .com, .net and .org.   3. Add the Validation Text: Enter a valid email address: myname@mycompany.com   4. Add a Caption: Enter your email address   If you want your users to be successful, then use the labels to offer instructions.

Table Tools -> Design ->Builder