List box, multiselect

  • Thread starter Thread starter TRM
  • Start date Start date
T

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!
 
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
 
Thanks. I thought I saw in the help file that it could
be set in VB. Must have been something else. THANKS!
 
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
 
Back
Top