List box, multiselect

[TRM]

I would like to programatically change a listbox
from "multiselect" to "standard" depending on how/what
the circumstances are. I'm getting an error that the
property cannot be updated (something similar).

Any ideas?

THANKS!

 

[Ron Weiner]

Sorry you cant do that. Access help clearly says that the MultiSelect
property can only be changed in Form Design.

You might want to consider having 2 listboxes on MultiSelect and the other
not both with the same RowSource, and flip their visibility as desired.
While this might be a little messy, it is doable.

Ron W

 

[TRM]

Thanks. I thought I saw in the help file that it could
be set in VB. Must have been something else. THANKS!

 

[Ron Weiner]

You CAN set this property programmatically with VBA BUT you have to open the
form in Design Mode to do it.

DoCmd.OpenForm "xxx" ,acDesign

Ron W