Create drop down/check box list in Access form where all that can apply can be selected

Question

I need to create a drop down/ check box list for a field in a form on MS Access.  The entries in the drop down / check box list should be listed in alphabetical order.  This needs to be a check box type of thing where ‘all that apply’ can be selected.  There also need to be an option for typing in fields not in the check box list. 

Please help! Is this possible in Access?

Answer 1

The article was helpful and I was able to create the combo box drop down, but now I am trying to figure out how to make an option where you can type in an additional option not included in the list...any insight?

Answer 2

Hi, What Daniel, Ken and I are all suggesting is that you NOT pursue that plan for a drop down box based on a Multi-Value Field. In my 2 decades of experience with Access, I've made nearly every possible mistake, some more than once. One I will not repeat,  though, is trying to use Multi-Value Fields in Access. It's a doughnut too many.

Ken's sample is a much more reliable way to proceed.

If you persist in going down the MVF path, of course, you'll gain a bit of experience that will serve you well in the future, but it'll come the hard way.