Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Telephone Field for Toll-Free numbers only 1

Status
Not open for further replies.

mjones219

Technical User
Jun 26, 2002
9
US
I need to restrict input in to a telephone field. I want to allow only the entry of an "8" as the first number in the input mask "(000) 000-0000". How do I make the first number only allow an "8"?
 
Using the following in the InputMask property of a sample table allowed me to have the "8" as the first character...and you don't even have to type the "8"....You just start with the 00 or 66 or whatever.

!"(8"00") "000\-0000;0;_ It's not important that someone else can do in one step what it took you ten to do...the important thing is that you found a solution. [spin]

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top