Text you entered isn't an tiem in the list BUT IT IS!

[heidii]

Hello All:

I have an issue:

I have a combo box on my form that looks up chemical products from
query.

I can select the combo box and use the dropdown to select chemicals to
add to the record. All has been working great until today. There is
one particular product that when I choose from the combo box list it
gives me the error "The text you entered isn't an item in the list".
Yet it is in the list. So far this is the only product that I know of
that does this action.

I have opened my backend tables and checked to see if there are any
differences in the products columns from the rest, but can not locate
any differences.

I tried changing the Autocorrect to off, and that did not work.

Any ideas?

heidi

 

[Rick Brandt]

Hello All:

I have an issue:

I have a combo box on my form that looks up chemical products from
query.

I can select the combo box and use the dropdown to select chemicals to
add to the record. All has been working great until today. There is
one particular product that when I choose from the combo box list it
gives me the error "The text you entered isn't an item in the list".
Yet it is in the list. So far this is the only product that I know of
that does this action.

I have opened my backend tables and checked to see if there are any
differences in the products columns from the rest, but can not locate
any differences.

I tried changing the Autocorrect to off, and that did not work.

Office AutoCorrect thinks it's a miss-spelled word and is changing it. Turn
off AutoCorrect on that control.

 

[heidii]

I tried changing the Auto Correct to off already that didn't work.
There were also no space at the end.

The combo box is pulling from a query of the chemical table.

I ended up deleting the offending record and re-inputing it. Then is
worked.

Another thought on the same record. I opened up the table and used my
filter. Typed in *Rayn* to bring up all those records. It would
bring all up except the offending culprit. But when I took the filter
off and scrolled to that record it is there.

It was spelled Raynox Water Softner
The others also started with Raynox.

It is working now, but not sure why it wasn't.