Microsoft KB Archive/90116

{|
 * width="100%"|

PRB: Cannot Delete Item When You Exit a LimitToList Combo Box
'Article ID: Q90116

Creation Date: 08-OCT-1992

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

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

When you delete an entry in a combo box, you may receive the following error message when you attempt to leave the control:

The text you enter must match an entry in the list. CAUSE

This behavior is by design in order to prevent Microsoft Access from adding nulls to the list just as it would any other new value. When the LimitToList property of a combo box is set to YES, no new values are accepted by the list, including nulls.

RESOLUTION

To add a blank entry to a combo box list, include a blank value in the combo box's source table. You can then select the blank value from the list rather than delete the entry in the field.

STATUS

This behavior no longer occurs in Microsoft Access for Windows 95 version 7.0.

MORE INFORMATION

Steps to Reproduce Behavior


 * 1) Create a form not based on any table or query. Add a combo box to the form and set the RowSource property to any table. Set the LimitToList property to Yes.
 * 2) Browse the form. Choose a value from the combo box and press ENTER. Note that the field is committed.
 * 3) Choose the combo box again. Delete the value and attempt to leave the control. Note that you receive the error message mentioned in the &quot;Symptoms&quot; section.

REFERENCES

For more information about the LimitToList property, search for &quot;LimitToList,&quot; and then &quot;LimitToList Property&quot; using the Microsoft Access Help menu.
 * }

-

"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.

''

Additional reference words: 1.00 1.10 2.00

KBCategory: kbusage

KBSubcategory: FmsCmbo