Hi,
I'm trying to set up an input mask for phone number with optional extension number.
I tried !(999) 000-0000 9999;;_
It works when there is an extension, but when there isn't, it shows like this after I tab out of the field.
( ) 12-3456 7890
I tried left justfied and right justified, but same thing.
This field is just for a note, so I don't want to create another field for extension.
I'm using Access2000.
Any suggestions are welcome.
Thank you!
YM
I'm trying to set up an input mask for phone number with optional extension number.
I tried !(999) 000-0000 9999;;_
It works when there is an extension, but when there isn't, it shows like this after I tab out of the field.
( ) 12-3456 7890
I tried left justfied and right justified, but same thing.
This field is just for a note, so I don't want to create another field for extension.
I'm using Access2000.
Any suggestions are welcome.
Thank you!
YM