Microsoft KB Archive/112132

INF: Must Save Table to Use Input Mask Wizard

Article ID: Q112132
Creation Date: 01-MAR-1994
Revision Date: 19-SEP-1996 The information in this article applies to:

Microsoft Access version 2.0, 7.0

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

Before you can use the Microsoft Access Input Mask Wizard in a table, you must first save the table if any changes have been made to it since it was last saved or if it has never been saved. If you attempt to use the Input Mask Wizard before the table is saved, you receive the following prompt:

   Must save table first. Save now?

MORE INFORMATION

Microsoft Access for Windows 95 version 7.0 and Microsoft Access 2.0 support the use of input masks to control the way data is entered and displayed in a field. An input mask can be used at table level, query level, or form level. If you apply an input mask with the Input Mask Wizard while in Table Design view, you are prompted to save the table first. This is necessary because the Input Mask Wizard is written in Visual Basic for Applications, and Visual Basic for Applications cannot determine whether the table has been altered. Once the table design is saved, the Input Mask Wizard operates correctly.

Steps to Reproduce Behavior

Open the sample database Northwind.mdb (or NWIND.MDB in version 2.0.
Open the Customers table in Design view.
Add a new field called Home Phone. Accept the default data type and size.
Click anywhere in the InputMask field property box, and then choose the Build button. Note that you are prompted to save the table. If you click No, the table is not saved and the Input Mask Wizard does not run. If you click Yes, the table is saved and the Input Mask Wizard operates as expected.

REFERENCES

For more information about input masks and the Input Mask Wizard, search for "input mask," and then "examples of input masks", using the Microsoft Access for Windows 95 Help Index.

Microsoft Access "User's Guide," version 2.0, Chapter 8, "Creating Input Masks for Data Entry"

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Additional reference words: 2.00 7.00 inputmask
KBCategory: kbusage
KBSubcategory: TblFldp