Microsoft KB Archive/95389

{|
 * width="100%"|

PRB: Error Using Edit Find with Yes/No Data Type
'Article ID: Q95389

Creation Date: 08-FEB-1993

Revision Date: 01-DEC-1996' The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

If you use the Find command on the Edit menu with a form that has a check box or radio button control bound to a field with a Yes/No data type, the Find command does not work correctly. When you enter Yes or No in the Find What box and run Find, you receive the following message:

In Microsoft Access 97 and 7.0:

Microsoft Access finished searching the records. The search item was not found. In Microsoft Access versions 1.x and 2.0: Microsoft Access has reached the end of the records. CAUSE

Although it appears that the check box is receiving the focus, the actual focus is on the label for the check box. The check box never receives the focus.

In Microsoft Access 97 and 7.0:

Even though the Search Only Current Field option appears dimmed in the Find box and even though the Search box is automatically set to All, the Find command still fails to find Yes/No data.

In Microsoft Access 1.x and 2.0:

Even though the Current option appears dimmed under Search In option in the Find box and even though the All Fields option is automatically set under Search In, the Find command still fails to find Yes/No data.

RESOLUTION

Do not use a check box or radio button if you want to be able to search on this field. You can search on a Yes/No data type if the field is a text box.

MORE INFORMATION

Steps to Reproduce Behavior


 * 1) Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0).
 * 2) Open the Products form in Form view, and click the Discontinued check box.
 * 3) On the Edit menu, click Find.
 * 4) Enter Yes or No in the Find What box. Click the Find Next button. Note that you receive the error message mentioned earlier in this article.

REFERENCES

For more information about check boxes, search the Help Index for &quot;check boxes,&quot; or ask the Microsoft Access 97 Office Assistant.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kbusage kberrmsg

KBSubcategory: FmsOthr

Additional reference words: 1.00 1.10 2.00 7.00 97 8.00 boolean