Change MultiSelect prop with VBA 
Author Message
 Change MultiSelect prop with VBA

Not possible, the property is "Read Only" during run time.
--
Doug
Reply to is anti-spammed remove the "z" from email


Quote:
>I need to dynamicly change the multiselect property of a listbox using VBA.
>I looked at help online and the multiselct property settings are:

>0=none
>1=simple
>2=extended

>I tried to set it to 0 like this:

>Me!lst.MultiSelect=0

>but this errors out.

>Can someone advise me on the proper syntax?

>Thanks.

>George Pavorac




Thu, 03 May 2001 03:00:00 GMT  
 Change MultiSelect prop with VBA
I need to dynamicly change the multiselect property of a listbox using VBA.
I looked at help online and the multiselct property settings are:

0=none
1=simple
2=extended

I tried to set it to 0 like this:

Me!lst.MultiSelect=0

but this errors out.

Can someone advise me on the proper syntax?

Thanks.

George Pavorac



Fri, 04 May 2001 03:00:00 GMT  
 Change MultiSelect prop with VBA
Perhaps you could just make 2 list boxes with the same dimensions, and
position... one with multi-select and one without. Then you could
enable/disable them appropriately based on you own multi-select setting.

HTH,
Greg


Quote:

> Not possible, the property is "Read Only" during run time.
> --
> Doug
> Reply to is anti-spammed remove the "z" from email



> >I need to dynamicly change the multiselect property of a listbox using VBA.
> >I looked at help online and the multiselct property settings are:

> >0=none
> >1=simple
> >2=extended

> >I tried to set it to 0 like this:

> >Me!lst.MultiSelect=0

> >but this errors out.

> >Can someone advise me on the proper syntax?

> >Thanks.

> >George Pavorac




Fri, 04 May 2001 03:00:00 GMT  
 Change MultiSelect prop with VBA
Well George the help file says :"This property can be set only in form
Design view."

HTH.

Robert Bolduc

George Padvorac a crit dans le message

Quote:
>I need to dynamicly change the multiselect property of a listbox using VBA.
>I looked at help online and the multiselct property settings are:

>0=none
>1=simple
>2=extended

>I tried to set it to 0 like this:

>Me!lst.MultiSelect=0

>but this errors out.

>Can someone advise me on the proper syntax?

>Thanks.

>George Pavorac




Fri, 04 May 2001 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. changing field prop's or copying data to another table

2. Change column prop - "required" via ADOX

3. changing printer prop., sending output to it (not a default prt) through Vb prog

4. MultiSelect File Listbox in Excel VBA?

5. Combo box with Multiselect (drop down list with multiselect)

6. Change the multiselect property at runtime

7. Common dialog style changes with multiselect ??

8. Error: Definitions of prop proc for the same prop are inconsistant...

9. Call Let/Get Prop using string variable for name

10. Call Let/Get Prop using string variable for name

11. Prop's of contacts

12. Restrict on prop. containing a string

 

 
Powered by phpBB® Forum Software