|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 4th, 2005, 10:33 PM
|
|||
|
|||
how do I set a input mask for email addresses
I want to force users to input a work related email address not hotmail or
yahoo. How do I create a mask that inputs the provider address that I want? i.e. all addresses will end with " 
|
|
#2
October 5th, 2005, 07:26 AM
|
|||
|
|||
|
Don't use an input mask. Instead, set a validation rule on the field:
Like " This will reject any address that doesn't end with @hope.com. On Tue, 4 Oct 2005 14:33:04 -0700, abnsgm wrote: I want to force users to input a work related email address not hotmail or yahoo. How do I create a mask that inputs the provider address that I want? i.e. all addresses will end with " -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.
|
|
#3
October 5th, 2005, 05:32 PM
|
|||
|
|||
|
John, thanks a lot. I was going about it incorrectly. Your information
helped me to acheive exactly what I needed. "John Nurick" wrote: Don't use an input mask. Instead, set a validation rule on the field: Like " This will reject any address that doesn't end with @hope.com. On Tue, 4 Oct 2005 14:33:04 -0700, abnsgm wrote: I want to force users to input a work related email address not hotmail or yahoo. How do I create a mask that inputs the provider address that I want? i.e. all addresses will end with " -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| input mask | DrEvil | Running & Setting Up Queries | 5 | May 5th, 2005 02:04 PM |
| Access 2000 input mask for IP addresses | nealc | General Discussion | 3 | February 15th, 2005 11:29 PM |
| input mask problem | G. Wolfe | Database Design | 1 | January 6th, 2005 05:01 AM |
| Can't find "Social Security Number" data in Input Mask Wizard Wind | azik | Database Design | 1 | January 1st, 2005 07:31 PM |
| Input Mask | Loi | New Users | 1 | November 18th, 2004 05:44 PM |
Linear Mode
