The multi-select listbox/dropdown/whatever with checkboxes

[Raj.Gabrielse]

Hi all,

Spent a good day searching the groups and learned that it does not
seem to be possible to use some type of dropdown with checkboxes.

I find it very hard to accept that a product like Office2k7 offers
such a flexible way to filter your data (dropdowns on column headers
in both Excel/Access) and not provide some interface to such a
dropdown for developers.

Is Access truly this back-to-stoneage that I have to buy/get me some
custom build controls library in order to have such flexible filtering
at my disposal as a starting developer? Or do I have to do this the
rough'n tough way and write it myself from scratch?

I've seen the various filter examples and demos, but there's nothing
that offers the same flexibility as these column header dropdowns.
(such as including blank as selectable _option_ instead of implied
blanks by not entering anything.)

Please show me the error of my ways and let me feel duly stupid for
not finding the answer (I'd love to be proven wrong on my assumtion)

Regards
Raj

 

[Dale Fye]

Raj,

I don't use 2007 (yet), but you are correct. There is "simple" way to
display a "listbox" with checkboxes. However, you do have the ability to use
multi-select listboxes, or, and I think this is what you really want, is the
ability to create a continuous subform that looks a lot like a listbox with
checkboxes. I think the other option is to use a treeview control, which
gives you the built-in checkbox functionality, but requires a bit more
codeing.

HTH
Dale