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
|
|||
|
|||
Input masks not being displayed
I'm a newbee to Access 2002 and I'm trying to figure out how to use input
masks. After I create an input mask (e.g., using the input mask wizard), I cannot get the mask to show up on any forms or on the Datasheet view. For example: * I create a blank database (e.g., db1.mdb) and then select "Objects | Tables | Create table in Design view." * I create the first field as an AutoNumber field with a Field Name of "ID" and I designate it as the Primary Key. * I create a second field as a Text field named "PhoneNumber". On the General tab for this field I specify the following Input Mask value: !(999) 000-0000;;_ * I save the table as "Table1". * I select "View | Datasheet view" from the main menu. When Table1 is displayed using the Datasheet view, the specified input mask for the PhoneNumber column is not displayed, even when a cell in the PhoneNumber column is selected for input. Likewise, any forms I create based on this table do not show the specified input mask. So what am I missing here? Why are the input masks not being displayed? Tia... Jim |
#2
|
|||
|
|||
The input masks will only show the place holder you have selected. When
incorrect data is added to a field with an input mask it will only check against it not show it. M. "jfischer_5809" wrote in message ... I'm a newbee to Access 2002 and I'm trying to figure out how to use input masks. After I create an input mask (e.g., using the input mask wizard), I cannot get the mask to show up on any forms or on the Datasheet view. For example: * I create a blank database (e.g., db1.mdb) and then select "Objects | Tables | Create table in Design view." * I create the first field as an AutoNumber field with a Field Name of "ID" and I designate it as the Primary Key. * I create a second field as a Text field named "PhoneNumber". On the General tab for this field I specify the following Input Mask value: !(999) 000-0000;;_ * I save the table as "Table1". * I select "View | Datasheet view" from the main menu. When Table1 is displayed using the Datasheet view, the specified input mask for the PhoneNumber column is not displayed, even when a cell in the PhoneNumber column is selected for input. Likewise, any forms I create based on this table do not show the specified input mask. So what am I missing here? Why are the input masks not being displayed? Tia... Jim |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Validating time-of-day input | Phil C | General Discussion | 1 | August 23rd, 2004 11:10 PM |
XL2003 Validation Input Msg Problem | Phil | General Discussion | 3 | July 28th, 2004 02:43 AM |
Input masks and (non) duplicate values | PeterC | Database Design | 1 | June 10th, 2004 09:59 PM |
Input Masks | Jackie | Worksheet Functions | 2 | February 5th, 2004 10:08 AM |
data validation input message | heather | Worksheet Functions | 2 | January 27th, 2004 03:56 AM |