motiv8td1
04-25-2007, 08:40 AM
I'm a total newbie in Access....is there a way to format a field in a table for a phone number so that when you put the info in it automatically puts the dashes in between the area code and such?
|
View Full Version : Telephone Number Field motiv8td1 04-25-2007, 08:40 AM I'm a total newbie in Access....is there a way to format a field in a table for a phone number so that when you put the info in it automatically puts the dashes in between the area code and such? pbaldy 04-25-2007, 08:55 AM Look at the Input Mask property. BrettStah 04-25-2007, 08:57 AM Here's an example of using the Format property to do it for a U.S. phone number: @@@-@@-@@@@ You would use an input mask to restrict the type of characters that could be inputted (to prevent the use of letters, for example). motiv8td1 04-25-2007, 09:03 AM Thank you both, worked perfectly!!! Joy:D |