Combo Box - Data Entry

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Is there a way to open the combo box when you enter that
field? My users do not want to select the arrow key to
open the box.
 
-----Original Message-----
Is there a way to open the combo box when you enter that
field? My users do not want to select the arrow key to
open the box.
.
Click to expand...
Yes, in the OnEnter event or the GotFocus event of the
combo box control try:
Me.YourControlName.Dropdown

HTH
Byron
 
Is there a way to open the combo box when you enter that
field? My users do not want to select the arrow key to
open the box.
Click to expand...

The mouse usually isn't needed AT ALL. If (as it is by default) the
combo's Auto Complete property is true, the user can use the <tab> key
to set focus to the combo, and just start typing. When the user types
B the combo will jump to the first entry starting with B; if they then
type O it will jump to the first entry starting with BO - which might
be Bob, in which case they can type <Enter> to accept your name as the
entry.

John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top