Multivalued lists

[KBDB]

How do I get the check boxes next to each of list items?

Is their a help screen somewhere?

 

[Allen Browne]

You can create a multivalued field (MVF) in Access 2007 only:

1. In table design, enter a field name, and in the Data Type choose Lookup
Wizard.

2. Go through the wizard indicating the information you want in the list,
and in the last screen, check the box for:
Allow Multiple Values.

Alternatively, on the Lookup tab (lower pane of table design), set the
Display Control to ComboBox, and Allow Multiple Values to Yes.

Before you do this, through, you need to be aware that this is llikely to
cause you problems later. There are several things that don't work for MVFs:
from basic things like problems querying the data and failure of the
OldValue of the MVF combo, through to inability to read/write to other
Access databases directly, and inability to convert to non-Access databases.

IMHO, you would be much better off designing a database with one-to-many
relationships you can see and use. This might help explain how to do that:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html

 

[aaron.kempf]

Or you could just use SQL Server and bitwise operators.

This would support up to 32 or 64 yes-no fields in a single numeric
column

-Aaron

 

[Tony Toews [MVP]]

Or you could just use SQL Server and bitwise operators.

This would support up to 32 or 64 yes-no fields in a single numeric
column

Which would be exceedingly ugly to setup now and maintain in the
future.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/