CAPS Lock on a combo box

[Carnage9270]

I have a form set up with a combo box that is set to auto expand, however if
I have my CAPS lock key on, it just moves the data aside. Does anyone know
how to fix this besides taking off my CAPS lock because I really need to ha
ve it on.

thanks!

 

[Marshall Barton]

I have a form set up with a combo box that is set to auto expand, however if
I have my CAPS lock key on, it just moves the data aside. Does anyone know
how to fix this besides taking off my CAPS lock because I really need to ha
ve it on.

Maybe you have a faulty keyboard. The behavior you're
describing is what would happen if it was the Insert key
instead of the Caps Lock key.

 

[Duane Hookom]

http://support.microsoft.com/default.aspx?scid=kb;en-us;824189 known issue:
"When you enable ANSI-92 SQL syntax in a database, and the RowSource
property for a combo box on the form does not include the DISTINCT keyword,
the AutoExpand feature of the combo box may not work.

In addition, if you type the value that is a part of the list, and then you
shift the focus to another control on the form, you may 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."