Input Mask

[Paula]

I am currently in an advanced Access class. I'm using Access XP. I am trying to convert 4 Works databases into an Access database. The purpose is to assign umpires to baseball games, and track how many games for each umpire etc. I am looking for an input mask that will display accept 18003569999 or 8003569999 and display the number as 1 (800) 356-9999 or (800) 356-9999 depending on if you type the 1 or not. My brother uses the computer to dial the phone numbers and we need the 1 with the area code if the number is not local. I've never built an Access database before. I am using this as my project for the class. Is there an input mask that will accept a telephone number with or without a 1
Thanks in advance for your help.

 

[Bart]

I would create a form using the input mask !\(999") "000\-
0000;;_ and add the 1 or remove the area code using
if/else string code if the area code is not local.

-----Original Message-----
I am currently in an advanced Access class. I'm using

Access XP. I am trying to convert 4 Works databases into
an Access database. The purpose is to assign umpires to
baseball games, and track how many games for each umpire
etc. I am looking for an input mask that will display
accept 18003569999 or 8003569999 and display the number as
1 (800) 356-9999 or (800) 356-9999 depending on if you
type the 1 or not. My brother uses the computer to dial
the phone numbers and we need the 1 with the area code if
the number is not local. I've never built an Access
database before. I am using this as my project for the
class. Is there an input mask that will accept a telephone
number with or without a 1?