Multi-Select Field on Form

B

bdehning

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?
 
B

bdehning

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

Rick Brandt

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

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.
 
Top