Input Mask for Phones

C

ClaireView

Most of my people have a single phone number, but some have two numbers. I
would like the option to do this: (800)552-1212 652-1212. I've tried
starting with the input mask for phones and then adding 9s, or adding #s, but
these don't work. Please help! Thanks.
 
D

Douglas J. Steele

Storing two numbers in a single field is a mistake. If you've got that
situation, you should have a separate TelephoneNumber table linked to your
existing table so that you can have multiple rows in the TelephoneNumber
table for those people.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Outlook: How do you create a Phone # input mask. 1
Remove input mask format 4
input mask for phone number 2
Custom, Automated Input Masks 2
Importing data with formatting mask 2
Data validation for input of date in the form of dd/mm/yyyy 1
input mask !!!! 3
Change FROM display name for Mobile Phones 3

Top