multiselect listboxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fjn - 11 Jun 2007 19:50 GMT

I am trying how to figure out how to set the value property of a multiselect
listbox (multiselect property = extended) programatically when the form
opens. However, Access only wants to let me set it in a listbox where the
multiselect property = none. Any ideas?

Thanks so much!

Signature

fjn

Reply to this Message

Douglas J. Steele - 11 Jun 2007 19:58 GMT

You cannot bind a multiselect list box: you have to set which rows are
selected manually by looping through the its rows, setting the Selected
property of each row to be selected to True.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I am trying how to figure out how to set the value property of a
>multiselect
[quoted text clipped - 3 lines]
>
> Thanks so much!

Reply to this Message

fjn - 11 Jun 2007 20:46 GMT

I did exactly that. But the user has to scroll down to find the selected row
as the selected row does not appear automatically.

Thanks.

Signature

fjn

> You cannot bind a multiselect list box: you have to set which rows are
> selected manually by looping through the its rows, setting the Selected
[quoted text clipped - 7 lines]
> >
> > Thanks so much!

Reply to this Message