telephone number set up

[Mary L. Smith]

I am having difficulty - I will do my best to describe...

I used the Table Wizard to set up...it defaults telephone
numbers as text so that it won't use the (999)999-9999
format when inputing in the table/form...

Can anyone please give me the format to put in the
properties section of the table...

Thanks so much

 

[John Vinson]

I am having difficulty - I will do my best to describe...

I used the Table Wizard to set up...it defaults telephone
numbers as text so that it won't use the (999)999-9999
format when inputing in the table/form...

Can anyone please give me the format to put in the
properties section of the table...

Text is the correct format for telephone numbers. They're not numeric
values in the sense that you'll ever be doing arithmatic with them;
they are identifiers which happen to consist of numeric characters.

You can set an Input Mask using the mask wizard to ensure that only
numeric digits are entered, and the parentheses and hyphen are added;
and you can use the Format property that you propose, with a text
field, perfectly well.