Text you entered isn't an tiem in the list BUT IT IS!
in [Forms]
|
From: heidii on 1 Jul 2008 14:51 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
From: ruralguy via AccessMonster.com on 1 Jul 2008 18:34 Any trailing spaces in the field? Is it case sensitive? heidii wrote: >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 -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com
From: John W. Vinson on 1 Jul 2008 18:41 On Tue, 1 Jul 2008 11:51:25 -0700 (PDT), heidii <heidii(a)zirklefruit.com> wrote: >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 Insufficient info! What's the RowSource of the combo box? What are the fieldnames and datatypes of the fields in the combo? What's the Bound Column, Control Source, and ColumnWidths properties of the combo? -- John W. Vinson [MVP]
From: Rick Brandt on 1 Jul 2008 19:20 heidii wrote: > 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
From: heidii on 2 Jul 2008 19:46
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. |