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

Hi Alexandria (biancoam),

I go through the post carefully, as per my test, I can add combo box as screenshot below:

 

Do you want something like this? Here is an article that may help: Create or delete a multivalued field

Hope these can help.

Regards,

Clark

Answer 2

Although multi values fields look very appealing be forewarned most experienced developer avoid them like the plague!

Why not simply use a listbox?

Another option would be a continuous form that you insert as a subform.

Things like Select All, are commands you need to create yourself.

Answer 3

To be clear here, Daniel is 100% correct, IMO. Multi-Value fields are seductive, but so is an extra doughnut with your morning coffee. Sooner or later, you come to regret it.

Answer 4

You might like to take a look at DatabaseBasics.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

In this little demo file the section on 'entering data via a form/subforms' includes a simple Contacts form in which one or more employers for each contact can be selected in a subform.  It also illustrates how a new employer can be typed in and inserted as anew row into the Employers table by means of code in the combo box's NotInList event procedure.

Answer 5

Hi Clark,

That is exactly what I want to do, but I want to do it within a form...does the same process apply? I believe that article was referring to a adding a new field within a table.

Thank you!

Ally