• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 546
  • Last Modified:

Formatting a number field to accept phone numbers

I currently have a phone number field with this input mask --   000\-000\-0000

When I try using this field to enter data I get an error message saying that I've entered too many numbers for this field's format.  I've tried all the available formats and even tried customizing my own, obviously to no success.  Someone please get me out of this mess!!  
0
Phreke2n
Asked:
Phreke2n
1 Solution
 
ssteevesCommented:
Try this.  (I'm using Access 97, so I don't know if we're in the same version).
Open your table in Design mode.  Click on the Phone number field.
In the Input Mask type the following:

!\(999") "000\-0000;;_

Save your table, and see if you don't have better luck.
0
 
brewdogCommented:
You won't be able to do what you're trying to do if this is a number field. Phone numbers, zip codes with plus 4, etc., all have to be text fields because of the dashes, slashes, and parentheses. Your input mask will work fine if you change your data type.

brewdog
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now