multiple values in listbox or combo box?

[TracyG]

Does anyone know how to create a list box or combo box that will allow the
selection of multiple values in the list?

 

[Doug Munich]

With a listbox you can change the MultiSelect property to Extended and get
then control-click or shift-click to select multiple values.

Doug

 

[Van T. Dinh]

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.

 

[TracyG]

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?

 

[Van T. Dinh]

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)