Multiselect property not available?

[Randall Arnold]

I have a need for a list control to have Multiselect set to None (0) on some
cases and Extended (2) in others. When I try to set the value
programmatically, however, I get an error from Access stating "You can't
assign a value to this object" (error 2448). Access Help insists that the
property is read/write--???

Any ideas?

Thanks,

Randall Arnold

 

[Douglas J. Steele]

My help file says "This property can be set only in form Design view."

 

[Microsoft News Groups]

Randall,

I had the same problem once.

I solved it by putting two identical listboxes on the form except that one
had MultiSelect set to None and one set to Extended. I changed the Visible
property depending on which one I wanted the user to access. This gives the
impression that a single listbox is changing between the two modes.

Rod Scoullar

 

[Cheryl Fischer]

Hi Doug,

In Access 2002, the Help file seems misleading. First, it says:

"You can set the MultiSelect property by using the list box's property
sheet, a macro, or Visual Basic. "

Then, it says:

"This property can be set only in form Design view."

And, at the end of the page, it provides a VBA example:

Forms("Order Entry").Controls("Country").MultiSelect = 2 ' Extended

which fails when you run it.

 

[Wayne Morgan]

You can open a form in design view using code, make the change, then save
it; but I do understand the confusion.

 

[Randall Arnold]

Thanks for all the feedback and ideas guys. Sounds like this control could
use an upgrade!

Randall Arnold