Prev: Form/subform setup
Next: Type mismatch
From: John Spencer on 30 Mar 2010 07:50 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 forest8 wrote: > 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 > > "John Spencer" wrote: > >> 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. >>>>> >>>> . >>>> >> . >> |