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 |
#1
|
|||
|
|||
combobox style
How do I go about changing the style of a combobox in Access 2000 from the
default to a simple combobox (i.e. show records in list at all times instead only showing records when arrow is clicked?)? I've seen articles on the 3 styles available, but none with an explanation on how to actually set it to the simple style. |
#2
|
|||
|
|||
combobox style
On Thu, 30 Oct 2008 11:58:01 -0700, mb wrote:
How do I go about changing the style of a combobox in Access 2000 from the default to a simple combobox (i.e. show records in list at all times instead only showing records when arrow is clicked?)? I've seen articles on the 3 styles available, but none with an explanation on how to actually set it to the simple style. The 'style' of a combo box? A combo box is a combo box. If you are looking to display the values at all times, then you want to use a LIST BOX. In Design view, right click on the combo box and select Change to List box. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
combobox style
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 "fredg" wrote: On Thu, 30 Oct 2008 11:58:01 -0700, mb wrote: How do I go about changing the style of a combobox in Access 2000 from the default to a simple combobox (i.e. show records in list at all times instead only showing records when arrow is clicked?)? I've seen articles on the 3 styles available, but none with an explanation on how to actually set it to the simple style. The 'style' of a combo box? A combo box is a combo box. If you are looking to display the values at all times, then you want to use a LIST BOX. In Design view, right click on the combo box and select Change to List box. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
combobox style
I know there are 3 styles of comboboxes. I just need to know how to set it
to the style I want. If anyone knows the coding to put in vba or the steps to take in design view, it would be greatly appreciated. "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 "fredg" wrote: On Thu, 30 Oct 2008 11:58:01 -0700, mb wrote: How do I go about changing the style of a combobox in Access 2000 from the default to a simple combobox (i.e. show records in list at all times instead only showing records when arrow is clicked?)? I've seen articles on the 3 styles available, but none with an explanation on how to actually set it to the simple style. The 'style' of a combo box? A combo box is a combo box. If you are looking to display the values at all times, then you want to use a LIST BOX. In Design view, right click on the combo box and select Change to List box. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#5
|
|||
|
|||
combobox style
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 |
#6
|
|||
|
|||
combobox style
You are describing a control that is specific to a data access page, rather
than a standard Access form. Here's the text from Access HELP: (drop-down list box: A control on a data access page that, when clicked, displays a list from which you can select a value. You cannot type a value in a drop-down list box.) Are you using a data access page? Regards Jeff Boyce Microsoft Office/Access MVP "mb" wrote in message ... How do I go about changing the style of a combobox in Access 2000 from the default to a simple combobox (i.e. show records in list at all times instead only showing records when arrow is clicked?)? I've seen articles on the 3 styles available, but none with an explanation on how to actually set it to the simple style. |
#7
|
|||
|
|||
combobox style
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 |
#8
|
|||
|
|||
combobox style
Thanks for your help. I don't know if the site I was looking at
(http://msdn.microsoft.com/en-us/libr...32(VS.60).aspx was specifically for a data access page, but I'm hoping to use this in an Access database form. "Jeff Boyce" wrote: You are describing a control that is specific to a data access page, rather than a standard Access form. Here's the text from Access HELP: (drop-down list box: A control on a data access page that, when clicked, displays a list from which you can select a value. You cannot type a value in a drop-down list box.) Are you using a data access page? Regards Jeff Boyce Microsoft Office/Access MVP "mb" wrote in message ... How do I go about changing the style of a combobox in Access 2000 from the default to a simple combobox (i.e. show records in list at all times instead only showing records when arrow is clicked?)? I've seen articles on the 3 styles available, but none with an explanation on how to actually set it to the simple style. |
#9
|
|||
|
|||
combobox style
mb wrote:
Thanks for your help. I don't know if the site I was looking at (http://msdn.microsoft.com/en-us/libr...32(VS.60).aspx was specifically for a data access page, but I'm hoping to use this in an Access database form. That page pretty clearly describes itself as a VB6 page, not an Access page. The control it describes cannot be used in Access unless there is an ActiveX version of it that you could utilize (bad idea). -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#10
|
|||
|
|||
combobox style
Ok. I figured VB6 just meant it was a newer version of VBA (where I put the
codes/modules). At any rate, I gave up on the idea last night when I found a work around (not pretty, but it works). Thanks everyone for your help. "Rick Brandt" wrote: mb wrote: Thanks for your help. I don't know if the site I was looking at (http://msdn.microsoft.com/en-us/libr...32(VS.60).aspx was specifically for a data access page, but I'm hoping to use this in an Access database form. That page pretty clearly describes itself as a VB6 page, not an Access page. The control it describes cannot be used in Access unless there is an ActiveX version of it that you could utilize (bad idea). -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
|
Thread Tools | |
Display Modes | |
|
|