One listbox works but the others don't

  • Thread starter Thread starter forest8
  • Start date Start date
F

forest8

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.
 
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
 
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
 
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
 
Hi

I can see the list but I'm not able to select any of the responses.

I was hoping to see a series of checkboxes so I can select responses but no
checkboxes appear.

Thanks
 
Now, I am confused.

A listbox would not display checkboxes. You select items in a listbox by
clicking in a row. That selects the entire row. There is no option to select
one item in the row.

If you need more help, please start a new thread. I am going to be offline
for the next few days.

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