A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

combobox style



 
 
Thread Tools Display Modes
  #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





  #12  
Old October 31st, 2008, 06:30 PM posted to microsoft.public.access.tablesdbdesign
MB
external usenet poster
 
Posts: 211
Default combobox style

Issue was already resolved.

"Klatuu" wrote:

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






  #13  
Old November 1st, 2008, 01:07 AM posted to microsoft.public.access.tablesdbdesign
Rick Brandt
external usenet poster
 
Posts: 4,354
Default combobox style

Klatuu wrote:
Rick Brandt is a world class expert and knows what he is saying. What he
is saying is correct.


Thank you, but I must humbly object. I have never considered myself any
higher that a village class expert. Though on at least one occassion I was
named a world class a**hole. Still have the plaque.

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.