Thread: combobox style
View Single Post
  #11  
Old October 31st, 2008, 04:44 PM posted to microsoft.public.access.tablesdbdesign
Klatuu[_3_]
external usenet poster
 
Posts: 396
Default combobox style

Rick Brandt is a world class expert and knows what he is saying. What he is
saying is correct.
The link to which you refer is not for Access, it is for classic VB. There
are many differences between the two.
So, the bottom line is there is only one kind of combo box in Access. The
info he provided is correct and complete.

That having been said, there are third party vendors that provide different
ActiveX controls you can download or purchase. You may try googling for
something like you are wanting.

Good Luck.

"mb" wrote in message
...
I'm not confused. I found the information through Microsoft
(http://msdn.microsoft.com/en-us/libr...2(VS.60).aspx). It's a
combobox, and I don't need it to allow multiple selections. I just need
the
style that keeps the list open.

"Rick Brandt" wrote:

mb wrote:
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.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com