Setting .MultiSelect property of ListBox error

  • Thread starter Thread starter Tony_VBACoder
  • Start date Start date
T

Tony_VBACoder

Why would I get the following error when I am trying to
set the .MultiSelect property of my list box?

"Run-time error '2448':
You can't assign a value to this object.


****** My Code *****
' Set the MultiSelect property to Extended
Me.listMeetingDate.MultiSelect = 2
 
Tony_VBACoder said:
Why would I get the following error when I am trying to
set the .MultiSelect property of my list box?

"Run-time error '2448':
You can't assign a value to this object.
Click to expand...

According to Help... that property cannot be changed from code.
 
Rick Brandt said:
According to Help... that property cannot be changed from code.
Click to expand...

Not quite, Rick. At least, my copy of help says "This property can be set
only in form Design view."

In other words, if you open the form in Design mode (one of the options with
DoCmd.OpenForm, you should be able to change it.
 
I am a little confused here. With Access 2002, if I bring
up the help on the "MultiSelect" property, here is what
the help says:

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

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

I am confused with the first part, because the help states
that you can set the MultiSelect property with Visual
Basic, but then it goes to say, it can only be set in form
Design View. So which is it???
 
As I said, you can set it using VBA, but only if the form's in Design view.
I don't see any contradiction to that in what the Help file says.
 
Tony_VBACoder said:
I am a little confused here. With Access 2002, if I bring
up the help on the "MultiSelect" property, here is what
the help says:

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

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

I am confused with the first part, because the help states
that you can set the MultiSelect property with Visual
Basic, but then it goes to say, it can only be set in form
Design View. So which is it???
Click to expand...

Being settable only in design view doesn't mean it has to be set
*manually*. You can have VBA code that opens the form in design view
(or switches it to design view), sets the property, and then switches to
form view.
 
Back
Top