Prev: Form/subform setup
Next: Type mismatch
From: forest8 on 28 Mar 2010 00:30 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.
From: John Spencer on 28 Mar 2010 11:52 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. >
From: forest8 on 28 Mar 2010 23:07 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. > > > . >
From: John Spencer on 29 Mar 2010 08:46 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. >>> >> . >>
From: forest8 on 29 Mar 2010 23:34
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. > >>> > >> . > >> > . > |