Would you like to specify what you mean when you say you can't get the
multi-select function to work?

Can you select multiple values in the listbox?

Are you trying to use the value property of the listbox and getting no result?
Multi-select listboxes do not have a value. Instead they have a collection
of items selected which you must use.

See The Access Web article
http://www.mvps.org/access/forms/frm0007.htm
for a sample.

If the problem is neither of the above, please describe it more fully than "I
can't get the multi-select function to work".


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

forest8 wrote:
Hi

I only have one column and the value column.

The thing is I can't get the multi-select function to work only the single
select works.

I need to have a multi-select list box in my database.

Thanks



"John Spencer" wrote:

You have a conflict in your settings.
Bound Column: 2
Column Count: 1
Column Widths: 0";1"

If your bound column is column 2 then you need at least two columns in column
count. This could cause problems.

How many columns in the row source? You should match the column count to the
number of columns in the row source.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

forest8 wrote:
Hi there

I have created a listbox called LB_Actions with the following:

Display Control: List Box
Row Source Type: Table/Query
Bound Column: 2
Column Count: 1
Column Widths: 0";1"
Allow Multiple Values: Yes
Allow Value List Edits: Yes


This one works fine. When I try to create a listbox called LB_NextSteps and
replicate the settings. It doesn't work., that is, I can't select any values
that appear in the list.

Another question: should I create the listbox first and then change the
settings or change the settings and then create the listbox. I can't find any
information on which should be completed first.

Thank you for your help.

.