CAPS Lock on a combo box


G

Guest

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!
 
Ad

Advertisements

M

Marshall Barton

Carnage9270 said:
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.
 
Ad

Advertisements

D

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top