If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to use a default value within an input mask
The telephone number field in the database I am working on
uses an input mask, i.e. !\(999") "000\-0000;;_ The area code is almost always going to be the same so I would like to display a default value, but continue using the input mask for entry of the last seven digits. How do I continue using the input mask and display a default value in the area code portion of the mask? Thanks in advance for any help you can provide. |
#2
|
|||
|
|||
I'm afraid you are asking the input mask to do more than it's capable of.
You might consider separating the Area code into its own field, setting a default for that field, and then concatenating it with the phone number for display. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Kathy" wrote in message ... The telephone number field in the database I am working on uses an input mask, i.e. !\(999") "000\-0000;;_ The area code is almost always going to be the same so I would like to display a default value, but continue using the input mask for entry of the last seven digits. How do I continue using the input mask and display a default value in the area code portion of the mask? Thanks in advance for any help you can provide. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
UK Postcode Input Mask | Negger | General Discussion | 4 | August 18th, 2004 07:47 PM |
DateTime field input mask | Jim Franklin | Using Forms | 3 | August 8th, 2004 05:19 PM |
input mask | lynn atkinson | Using Forms | 2 | July 29th, 2004 06:29 PM |
Input Mask Error | Ann Shaw | Database Design | 1 | June 16th, 2004 07:00 PM |
Input Mask not working ? | TonyB | Database Design | 4 | May 11th, 2004 11:26 PM |