View Full Version : Phone Number Suggestion


roberemok
07-02-2005, 06:53 PM
What is the best way to setup a phone number field that will contain numbers from North America and Europe?

Is it just one field that is text and no input mask? :)

Any suggestions?

Thanks

ssteinke
07-02-2005, 07:30 PM
A lot of people don't like to use the Access Input Mask because of its limitations. I've noticed my users always want to click in the middle of the field, causing the the number they are entering to start being entered in the middle, instead of the beginning.

You might want to try a text box with a function to format the phone number on the lost focus of the field.

mresann's code in this thread might get you started and give you some ideas

http://www.access-programmers.co.uk/forums/showthread.php?t=79979