ACC: Find Action Fails When Input Mask Doesn't Match Data

 Last reviewed: May 30, 1997
Article ID: Q145655
The information in this article applies to:
  • Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

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

If you add an input mask to a table that already contains data, the Find feature fails to work properly when the field's data does not meet the criteria of the input mask. For example, in Microsoft Access 2.0, a Find action fails if you type a string into the Find What box and include the input mask field in the search criteria (by selecting the All Fields or the Current Field option). In Microsoft Access 7.0 and 97, a Find action fails if you type a string into the Find What box and select the All Fields option.

RESOLUTION

You can work around this situation in the following ways:

  • Do not include the input mask field in the Find criteria.
  • Remove the input mask, perform the Find action, and then add the input mask back.
  • Modify data in the input mask field to meet the criteria of the input mask.

REFERENCES

For more information about the Find feature, search the Help Index for "finding data," or ask the Microsoft Access 97 Office Assistant.

Keywords : kbusage TblProb
Version : 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : kbworkaround

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.

Last reviewed: May 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.