Solved

Formatting a number field to accept phone numbers

Posted on 1998-12-30
2
535 Views
Last Modified: 2008-02-26
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
Comment
Question by:Phreke2n
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
ssteeves earned 50 total points
ID: 1972333
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
 
LVL 10

Expert Comment

by:brewdog
ID: 1972334
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question