L
Leoram
Guest
I have designed a form in Access 2000. I need my Telephone field in its subform to automatically change the phone number format entered based on the number entered from "0" to "9999999999", that is, according to the following criteria:
From # to: Format:
0-9 = Blank
10-9999 = #### (For any extension No.)
10000-999999 = Blank
1000000-9999999 = ###-####
10000000-99999999 = #-###-####
100000000-999999999 = Blank
1000000000-9999999999 = (###) ###-####
Any help will be appreciated.
Leoram
From # to: Format:
0-9 = Blank
10-9999 = #### (For any extension No.)
10000-999999 = Blank
1000000-9999999 = ###-####
10000000-99999999 = #-###-####
100000000-999999999 = Blank
1000000000-9999999999 = (###) ###-####
Any help will be appreciated.
Leoram