Custom Combo Box

[k6saunde]

Hey All,



I am working on a Access 2016 32bit. I need to figure out how to create a combo box that has Check boxes inside of it. When each of the check boxes are selected those values are then displayed in the combo box field. See Pictures

Any help is appreciated

Thanks,

Keith

[vicsaccess]

sounds like you are after a multi select list box instead of a combo box. do a quick google search and it should come up with some good ones.

[k6saunde]

It actually appears it is a multi select list box inside a combo box. When I left click on it and go to "change to:" List Box is an option as is Text Box. I have been searching for info on this for days without any luck. That is why I posted here. I could really use some help with this ASAP.

[vicsaccess]

ok, now i remember these, i was asking about them a while back. look at these two links
https://support.office.com/en-us/art...9-A62B47A4EE27
http://www.kallal.ca/Articles/fog0000000006.html

i liked the look of them but didn't like the lack of normilization, moved on.

[ssanfu]

I think what you are looking for is a Multi Valued Field. You define it in table design view.
Having said that, no experienced programmer I know or have heard of uses MFVs.

You might read this http://stackoverflow.com/questions/1...ds-a-good-idea

Using a MFV sounds good in the beginning, but is a pain in the a## later on. I would recommend not using MFVs.

[k6saunde]

Steve,

How would you do what I am trying to accomplish?

[ssanfu]

Nothing saying you can't use MFVs in your tables.... but I won't use them.
I think you will have issues later on in queries and/or reports. I don't think even if you used a MFV that it would display like the right most combo box in your picture. But I don't know for sure because I just don't use them.

I would create create a junction table and use a multislect list box or a sub form. You will have to use code to get the values from the multislect list box and put them in a table.
A sub form takes more space; the list box uses more code.