mb said:
No. I want to display a combo box that show all the values in the
list and allows users to type in values that are not in the list in
the textbox of the combobox. What I've read so far is this:
There are three combo box styles. Each style can be set at design
time and uses values, or equivalent Visual Basic constants, to set
the style of the combo box.
Style Value Constant
Drop-down combo box 0 vbComboDropDown
Simple combo box 1 vbComboSimple
Drop-down list box 2 vbComboDropDownList
You are confused.
A ComboBox never shows its list unless you drop it with the arrow or with
code. It cannot be made to be dropped when it does not have focus.
A ComboBox has a property LimitToList that determines whether the user can
type an entry that is not in the list. In a Multi-Column ComboBox this is
only allowed when the bound column is also the displayed column.
A ComboBox never allows multiple selections.
A ListBox always displays as many rows as its height allows. Youc an scroll
to see the rest. It never allows you to deviate from its list.
A ListBox has a MultiSelect property that can be set to "None", "Simple" or
"Extended". The first means only one row can be selected while the latter
two allow multiple selections. The latter two also make a ListBox useless
as a bound control because a Multi-Select ListBox always has a value of
Null.
You seem to be describing something that has properties of both a ComboBox
and a ListBox. There is no such native control in Access. You might have
been lead astray by Access help which will often take you to a help topic
for a completely different Office product than the one you started in.
