Multiselect property not available?

  • Thread starter Thread starter Randall Arnold
  • Start date Start date
R

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
 
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
 
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.
 
You can open a form in design view using code, make the change, then save
it; but I do understand the confusion.
 
Thanks for all the feedback and ideas guys. Sounds like this control could
use an upgrade!

Randall Arnold
 
Back
Top