Why does Access fire KeyDown event when combobox list is being displayed?
Posted on 2003-11-09
I'm running into a problem with tabbing. I have a form which is like
a spreadsheet, and I've implemented Excel-like navigation by catching
the KeyDown event and if it is a vbKeyDown or vbKeyUp (and no shift or
Alt key is pressed) then I move to the next or previous row.
This works fine.
The problem is that my combo boxes no longer work after adding the
code to catch vbKeyDown.
The problem is this: When I am on a combo box and ALT vbKeyDown is
pressed, the MS-Access displays the combobox list. If I try to use
the up or down arrows to navigate within this combobox list, it
instead moves to the previous or next rows. This happens because
Access is firing the keydown event when the combobox list is being
IMHO, this is a bug. Access should not fire those events when the
combo-box is being displayed.
(Q) Is there a way to prevent these from being triggered?
(Q) Or is there a way to know when the combo box is being displayed so
I can detect this condition and not move focus to the next or