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