Multi-select checkboxes

[Isaac]

Do you ever have the desire to display a multi-select checkbox, if so, how do you do it? Is it built in to Access?
I know I can draw multiple individual checkboxes on the screen, but I want to squish them all into a scroll-able area.

 

[MajP]

Not sure what you mean. Is this a listbox with checkboxes? If so I do it the same way as mentioned here where I fake a Multi value listbox

Solved - How to add a checkbox on a Continuous Form

Hi; I am trying to add a checkbox on a continuous form in order to select "employees" that I will send an Email to them. the data (on the continuous form) comes from query, now if I checked or unchecked the checkbox on the form detail, all of them will have the same behavior. I don't want to...

www.access-programmers.co.uk

In that example it is a pop up, but you can do it as a subform.

As described it also sounds like an option group formatted with checks instead of radio buttons

 

[theDBguy]

Hi. I never have the desire, but if someone asks, you can do it using a Multi-Value Field.

 

[Isaac]

Thanks gentlemen. Thanks Majp for the reference to the other method.
After consideration, I'll stick with a multi select Listbox to achieve roughly the same functionality I guess.

 

[MajP]

After consideration, I'll stick with a multi select Listbox to achieve roughly the same functionality I guess.

@Isaac. It is kind of unfortunate that access does not have a native listbox with checks. People always want that, it is a nicer presentation IMO. The listview had that options, but those are just a pain to work with (no documentation).

 

[Isaac]

Agreed, it would be nice. Thankfully at least there is the MultiSelect-Simple property value which is about as close as I can get.

 

[MajP]

@Isaac
You may find this interesting. Simple to use and seems to works well.

Solved - How to add a checkbox on a Continuous Form

Hi; I am trying to add a checkbox on a continuous form in order to select "employees" that I will send an Email to them. the data (on the continuous form) comes from query, now if I checked or unchecked the checkbox on the form detail, all of them will have the same behavior. I don't want to...

www.access-programmers.co.uk

 

[MajP]

I added 2 useful features to allow you to use the selections. I return a collection or a dictionary of the selections and provide a comma seperated list.

 

[theDBguy]

Hi. I never have the desire, but if someone asks, you can do it using a Multi-Value Field.

Just to clarify for others, this is what I meant. MVF1 is a Combo, and MVF2 is a Listbox.