Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Access question

Status
Not open for further replies.

dvraggs

Technical User
Jan 30, 2002
22
0
0
US
I need and inputmask to be 999-A-9999. The 9 can be any number and the A is Alpha. Can anyone help.
 
Create your own Input mask by using the Input Mask Wizard built in to Access.

Open your Table or Form in Design view and select the Field or Control you want to add the Input Mask to. In the Property Sheet, locate the Input Mask property and click on it to select it.

To the right of the text area you should now see an ellipse (...). Click on the ellipse to start the Input Mask wizard. Then just follow the prompts.

Note, however, that input masks will only work with text or number fields.

HTH
Lightning
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top