K
KBDB
How do I get the check boxes next to each of list items?
Is their a help screen somewhere?
Is their a help screen somewhere?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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
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
A
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
This would support up to 32 or 64 yes-no fields in a single numeric
column
-Aaron
T
Tony Toews [MVP]
[email protected] said: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/