Input of phone numbers

[mscertified]

I want to force input of U.S. phone numbers in 999-999-9999 format. I will
store the numbers and the dashes. How do I create an input mask to enforce
this? The existing mask forces (999) 999-9999 which I don't want.

Thanks.

 

[Chris]

You should be able to just key the mask that you want without using the
wizard. I have a database where I use the mask 99-99999-99-9. This does not
store the dashes which IMHO provides more flexibility should you one day
decide to change how the numbers are displayed.

 

[fredg]

I want to force input of U.S. phone numbers in 999-999-9999 format. I will
store the numbers and the dashes. How do I create an input mask to enforce
this? The existing mask forces (999) 999-9999 which I don't want.

Thanks.

999\-000\-0000;0;_

 

[Klatuu]

Chris is correct. Storing the dashes is not a good idea. It only takes up
disk space. You can always put the dashes back in when you display it to a
user.

Format([PhoneNbr], "999-999-9999")