Multi-Select Field on Form

[Guest]

What do I use if on a Form I would like to have a field that if clicked, 12
choices in a list would appear and the user could select all 12 choices and
possibly a check mark is next to the selections?

 

[Guest]

Also, is it possible to have field expand on the form for as many choices are
selected and all choices visible on the form.

 

[Rick Brandt]

Also, is it possible to have field expand on the form for as many
choices are selected and all choices visible on the form.

Storing multiple values in a single field is a big no-no for proper database
design. If you "think" you need multiple values in a field what you actually
need is a second related table. Then using a subform you are free to enter
anywhere from zero to "however many" items with each one being a distinct row in
the new table.