Toggle MultiSelect Property

[skea]

Does any one know of a way to toggle a multiselect listbox's property programmatically?
The One In The VBS Help doesn't work!

 

[RuralGuy]

Hi skea,
Which property? The MultiSelect property has three states so toggle doesn't really make sense. What is the VBS example?

 

[skea]

Sorry! the 'S' is near an 'A' on my keyboard. I meant 'Access VBA Help Files'
I have a multiselect with a simple(1) and not None(0) or Extended(2) property.
I want to change the property from simple to None when i load my form.
The Access Help File tells me that

To set the MultiSelect property, you can use the following:

Forms("Order Entry").Controls("tbCountry").MultiSelect = 0 ' None

But it isnt working for me!!

 

[RuralGuy]

It also states: "This property can be set only in form Design view."

I think this is simply a slip up on MS's part. The example is as if you were not in the form's code but executing it from another form after having opened the form in acDesign mode. You really have to read between the lines on this one.

 

[skea]

Thanks RuralGuy. yap its a complete slip. Hope they review it.
They wouldnt even have put the example in the help files.

 

[RuralGuy]

You're welcome. Glad I could help.