Hi I am trying to change the listbox to multiselect simple in my form via vba
but am coming up with the following error
Code:listFunctions.MultiSelect = 0
can anyone tell my why?
Competent Performer
Windows 7 64bit 
Access 2010 32bit
Hi I am trying to change the listbox to multiselect simple in my form via vba
but am coming up with the following error
Code:listFunctions.MultiSelect = 0
can anyone tell my why?
Who is John Galt?
Windows XP Access 2007
From help:
This property can be set only in form Design view .
Access Developer
Windows XP Access 2003
Perhaps this is one of the from properties that can only be changed when the form is in Design View
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Competent Performer
Windows 7 64bit Access 2010 32bit
so does this mean It cant be done?
Access Developer
Windows XP Access 2003
I think it can be done by opening the form in Design mode first, then changing the property, closing the form and saving the change, then opening the form as usual.
I think I would look at some other way of achieving the same effect. Perhaps a duplicate list box that is hidden until required.
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Multi select List box
Allen Browne's Use a multi-select list box to filter a report with Two List Boxes
Posting Permissions
Reply With Quote