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
input mask for phone number 2
Custom, Automated Input Masks 2
Remove input mask format 4
input mask !!!! 3
Input Mask 1
Convert form field data OnExit 1
How do I update input mask across tables 4

Top