Dropdown Listbox

[XMan]

Is there a dropdown listbox control?
I see only either combobox or listbox.
TIA.

 

[Bob Howard]

That's called a combo box...

 

[Wayne Morgan]

A combo box is frequently referred to as a dropdown listbox. Try it and see
if that is what you're after.

 

[XMan]

I don't want user to type in the box.
They can only drop the list and select.
Maybe there's a property that I'm missing.

 

[Rick Brandt]

I don't want user to type in the box.
They can only drop the list and select.
Maybe there's a property that I'm missing.

Access has no such control. You can size a ComboBox horizontally so that
all you see is the arrow but they will still be able to type in it (they
just won't be able to see what they're typing). LimitToList = Yes would
restrict them to typing only an entry that matches one of the choices in the
list though.

 

[Wayne Morgan]

Rick's answer is the best, limit them to what is in the list but let them
type. You can prevent any typing though by using code. In the KeyDown event
of the combo box set KeyCode = 0. This will cancel their keyboard input.
However, this will cancel ALL of their keyboard input while the combo box
has the focus, including being able to press Esc to undo an unwanted change
to the combo box. You could use an If statement to allow certain keys, but
cancel the others.