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
|
|||
|
|||
multiple values in listbox or combo box?
Does anyone know how to create a list box or combo box that will allow the
selection of multiple values in the list? |
#2
|
|||
|
|||
multiple values in listbox or combo box?
With a listbox you can change the MultiSelect property to Extended and get
then control-click or shift-click to select multiple values. Doug "TracyG" wrote in message ... Does anyone know how to create a list box or combo box that will allow the selection of multiple values in the list? |
#3
|
|||
|
|||
multiple values in listbox or combo box?
Not ComboBox but you can use the Multi-Select ListBox. However, you should
note that the Value of the Multi-Select is *always* Null so it is not simple to use Multi-Select ListBox. See The Access Web article: http://www.mvps.org/access/forms/frm0007.htm for an example on using Multi-Select ListBox. -- HTH Van T. Dinh MVP (Access) "TracyG" wrote in message ... Does anyone know how to create a list box or combo box that will allow the selection of multiple values in the list? |
#4
|
|||
|
|||
multiple values in listbox or combo box?
I am not clear on your response regarding the values as nulls. I tested and
I see that it does not seem to store the values selected on the list box. If my testing is valid, then is it not possible to store the values in a table for future reference? |
#5
|
|||
|
|||
multiple values in listbox or combo box?
You test confirm what I wrote (the value of the Multi-
Select ListBox is always Null). Of course it is possible to store the values selected but you will need to consider how to store the multiple values selected since you can select multiple items in a Multi- Select ListBox. For example, you can modify the code in the link I posted to create a list of values selected. However, you should NOT store these values as a list since the first Principle of the Relational Database Design Theory (RDDT) states that "data should be atomic" meaning each Field Value (in a Table) should only store a *single* item of data, NOT a list of items / values. Perhaps, you need to look up on RDDT and decide how you should store these values in an appropriate Table Structure first before worrying about the GUI. HTH Van T. Dinh MVP (Access) -----Original Message----- I am not clear on your response regarding the values as nulls. I tested and I see that it does not seem to store the values selected on the list box. If my testing is valid, then is it not possible to store the values in a table for future reference? . |
Thread Tools | |
Display Modes | |
|
|