Listbox multiselect status

[Sam23]

I would like to programmatically change the ListBox.Multiselect property setting. Part of the time I want it set to "Extended" to open multiple documents. Other times I need the property set to "none".

The following line causes error that property is being used improperly:

Me.LstListBox.MultiSelect = 0 'none

I tried both setting the focus off the listbox and on the listbox and neither option seems to resolve the issue.

Thanks for the help.


Sam

[pbaldy]

Are you aware that the multiselect property can only be set in design view? From the sound of it, I'd probably leave it as multiselect and only allow the user a single selection programmatically under the appropriate circumstances.

[Paul H]

Paul,

" allow the user a single selection programmatically under the appropriate circumstances"

How would you do this if you can only make the change in Design View?

or rather how would you use this code scraped from VBA Help?

Forms("frm_Report_Menu").Controls("Lst_Filter").MultiSelect = 0

[pbaldy]

No, I'd test like:

If Me.ListboxName.ItemsSelected.Count > 1 Then

which would tell you the user selected more than one item.

[Paul H]

Thanks, I will use this in the future.

[pbaldy]

No problem; us Paul's have to stick together.