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

Signature
Wayne Morgan
MS Access MVP
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.
> A combo box is frequently referred to as a dropdown listbox. Try it and see
> if that is what you're after.
>
> > Is there a dropdown listbox control?
> > I see only either combobox or listbox.
> > TIA.
Rick Brandt - 26 May 2005 22:24 GMT
> 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.

Signature
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Wayne Morgan - 26 May 2005 23:28 GMT
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.

Signature
Wayne Morgan
MS Access MVP
>I don't want user to type in the box.
> They can only drop the list and select.
[quoted text clipped - 7 lines]
>> > I see only either combobox or listbox.
>> > TIA.