Change to MultiSelect by code

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hello,

I have the following code:

Forms("MainMenu").Controls("MyList").MultiSelect = 2

I want to convert it to a multi select if the user wants to however I get an
error box saying I cant assign a value to this object (which is a list box).

Can anyone help?

Thanks in advance

Martin
 
Take a look at this:
http://www.fontstuff.com/access/acctut11.htm

It may be simpler than you think. If you go into Design View, click
Properties, then click All, Multi Select, Simple. go back to Form View and
try it. That will allow a user to click several items in the ListBox. Multi
Select, Extended will allow a user to click multiple items by holding down
the Ctrl key and clicking items with the mouse.
 
Hello,

I have the following code:

Forms("MainMenu").Controls("MyList").MultiSelect = 2

I want to convert it to a multi select if the user wants to however I get an
error box saying I cant assign a value to this object (which is a list box).

Can anyone help?

Thanks in advance

Martin
Click to expand...

Are you sure you wish to allow the user to change this property?
While the form is open? Using code?
While the form is open, you need to also open the form in design view.
Make the change.
Close the chanvged form and save the changes.
Then re-open the form in Form View.

Code a command button's Click event:

DoCmd.Echo False
DoCmd.OpenForm "FormName", acDesign, , , , acHidden
Forms!FormName!ListBoxName.MultiSelect = 2
DoCmd.Close acForm, "FormName", acSaveYes
DoCmd.OpenForm "FormName"
DoCmd.Echo True

Are you aware that you will need to use code to read and do something
with the multi selected values in the List Box?
 
Martin said:
Hello,

I have the following code:

Forms("MainMenu").Controls("MyList").MultiSelect = 2

I want to convert it to a multi select if the user wants to however I get
an
error box saying I cant assign a value to this object (which is a list
box).

Can anyone help?

Thanks in advance

Martin
Click to expand...

It's not possible to change a listbox's multiselect property at runtime. You
can only do this when the form is open in design view.

That said, there is a workaround: Create another listbox with the same
dimensions as your original. Set the multiselect property appropriately and
the visible property to No/False. Position this new listbox directly
covering the other one. When you want to change to multiselect mode, hide
the original listbox (Me.ListboxName.Visible = False) and show the new one.
To go back to no multiselect, reverse the process.
 
Hello,

I have the following code:

Forms("MainMenu").Controls("MyList").MultiSelect = 2

I want to convert it to a multi select if the user wants to however I get an
error box saying I cant assign a value to this object (which is a list box).

Can anyone help?

Thanks in advance

Martin
Click to expand...

You can only change the properties of a listbox in Design view; it sounds like
you're trying to change it on the fly while the form is open. I don't believe
that you can do so.

What's the context?
 
Martin said:
Hello,

I have the following code:

Forms("MainMenu").Controls("MyList").MultiSelect = 2

I want to convert it to a multi select if the user wants to however I get
an
error box saying I cant assign a value to this object (which is a list
box).

Can anyone help?
Click to expand...


As others have said, you can't change the list box's MultiSelect property at
run time. I believe you could use code in various events to make a
multiselect list box behave like a single-select list box, depending on a
flag you'd set.
control.
 
Thank you all for your replies, certainly a few things to think about.

Stuart - I am going to take your approach, seems the best work around and
will look seemless for the user.

Many thanks

Martin
 
Martin said:
Thank you all for your replies, certainly a few things to think about.

Stuart - I am going to take your approach, seems the best work around and
will look seemless for the user.

Many thanks

Martin
Click to expand...

I meant to say in my previous that the downside to the technique is that you
must fill both lists when the form loads, unless they're fast enough to fill
at the time you switch.

Also it may be worth changing some attribute of the multiselect list, like
the backcolor, or font, so the user knows which one he/she is looking at.
 
Back
Top