Multi-Select Field on Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Also, is it possible to have field expand on the form for as many choices are
selected and all choices visible on the form.
 
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.
 
Back
Top