"The Text You Entered Isn't an Item in the List" error message when you programmatically add a new record to a table by using the NotInList event of the Combo Box on a form (824176)
The information in this article applies to:
- Microsoft Office Access 2003
- Microsoft Access 2002
- Microsoft Access 2000
OfficeNet:222104 This article applies only to a
Microsoft Access database (.mdb). For a Microsoft Access 97 version of this article,
see
161007. Moderate: Requires basic macro, coding, and interoperability
skills.
SYMPTOMSWhen you try to programmatically add a new record to a table
by using the NotInList event of the combo box on a form, you might receive the following
error message: The text you entered isn't an item in the
list.
Select an item from the list, or type the text that matches one
of the listed items. However, the new record is successfully added to
the table. As a result, the new item that you entered is added to the list of
items in the combo box. CAUSE This problem occurs when the combo box is bound to a Number data type column and the format property for the column is set to
Currency or to Euro. WORKAROUNDTo work around this problem, type the value in the combo box
that matches the format of the column that the combo box is bound to. For
example, if the format of the column is Currency, type $20 instead of
20.
However, if the format of the column is set
to Euro, you might not be able to enter a number that matches the format
of the column.
Note If you reset the Format property of the column,
the problem does not occur.REFERENCES For more
information about the NotInList event, click Microsoft Access
Help on the Help menu, type NotInList
Event in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
For additional information, click the following article number to view the
article in the Microsoft Knowledge Base: 197526
ACC2000: Use NotInList Event to Add a Record to Combo Box
Modification Type: | Minor | Last Reviewed: | 6/8/2004 |
---|
Keywords: | kbformat kbEvent kberrmsg kbDataBinding kbComboBox kbprb KB824176 kbAudDeveloper |
---|
|