combo box - the text you entered isn't an item in the list

[Guest]

I have a dB that has some combo boxes and the users have been getting the
following error when typing in the item they are attempting to look up and
then hitting enter: 'The text you entered isn't an item in the list'

However, if they scroll the combo box, the item is there and they can select
it.

This dB has been in use for months and this only started in the last few
days. I cannot replicate the error on my development copy.

The dB is compiled so there is no chance anyone changed any of my code.

Any ideas?

 

[Guest]

Hi,
I faced the same error. I tried many number of times and I got the same
response. When I observed closely I found the error. It may not be the case
but its worth the try checking it. I had mis-spelled one option and after I
select that option Access is automatically correcting the spelling and hence
the item is not one of the list items.


vb

 

[BryanF]

I had the same problem but 95% of the responses were usually on how to suppress the warning. what was causing my issue was that I had blank field values in the query results. As soon as I filtered out the NULL values with Is Not Null in the field for the query, issue was resolved. Hope this helps.