Solved

Formatting a number field to accept phone numbers

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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.

839 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