Solved

Formatting a number field to accept phone numbers

Posted on 1998-12-30
2
523 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
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

705 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now