Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 208508 - Last Review: July 15, 2004 - Revision: 1.1
ACC2000: Input Mask Wizard Not Available with All Data Types
This article was previously published under Q208508
Novice: Requires knowledge of the user interface on single-user computers.
When you try to invoke the Input Mask Wizard, you may receive the
following error message:
The Input Mask Wizard only works with Text or Date fields.
You can use the Input Mask Wizard with Text and Date/Time data types, but
you cannot use it with Memo, Number, Currency, Counter, Yes/No, or OLE
Object data types.
If you cannot use the Input Mask Wizard, enter the input mask manually in
the
InputMask property.
You can invoke the Input Mask Wizard by clicking the
Build button to the right of the
InputMask property. The
InputMask property applies to table fields, query fields, and text box controls on forms and reports. You can use the Input Mask Wizard with Text and Date/Time data types, and, in forms and reports, you can use it with unbound text box controls. If you try to use the Input Mask Wizard with any other data types, you receive the error message mentioned in the "Symptoms" section.
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb.
- Open the Employees form in Design view.
- Click the EmployeeID text box control
- If the property sheet is not displayed, on the View menu, click Properties.
- In the Properties dialog box, click the InputMask property on the Data tab, and then click the Build button to invoke the Input Mask Wizard.
For more information about input masks, click
Microsoft Access Help on the
Help menu, type
Define an input mask for a field in a table in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate