Not In List Error Message

[Jason S]

I am getting the error message in my combo box "The text you entered isn't an
item in the list" even though the item is indeed in the list. I can open the
drop down list and manually find the value. This function had been working
fine for over a year, but obviously something has changed. The problem is I
don't know what has changed. Any thoughts?

 

[JimBurke via AccessMonster.com]

I'm assuming this is a text field. It's possible that you have some trailing
blanks in some of the fields that are stored in the underlying table. To test
this, create an after update event procedure in the combo box and it put a
msgbox statement that shows the length of the combobox field. For a value
that you are having the problem with, select the value from the combobox
(scroll to it and select it), and the msgbox will display the length of the
value. See if it the length is what you woud expect it to be. If you have,
for example, "abc " stored, the length will come out as 5 rather than 3. I
had this happen once when I created new table columns through DDL in my
application and I didn't use "TEXT for the field type - I think I had used
'CHAR" instead, which can potentially add trailing blanks.