Telephone Imput Mask Not Working

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

Every time I put in a telephone #, a message pops up
saying that the field size setting does not permit my
entry. But I am using the imput mask, so shouldn't it
work? What am I doing wrong?
 
The field size was set at long integer, but actually I
think what the real problem was is that I had my data type
set on Number and the imput mask wouldn't work until I
changed it to Text. Thanks for your help!
Click to expand...

Yes, telephone numbers should be stored as Text fields, not Number
fields. If you include the area code with the phone number, and try to
store it in a Long Integer field, a phone number like

(201) 123-4567

will fit, because the number 2,011,234,567 will fit in a long integer,
but a phone number like

(301) 123-4567

won't fit, because 3,011,234,567 exceeds the capacity of that field
size.
 
Back
Top