Rick's idea of using a related table where you can store anywhere from zero to
"however many" and use a subform to do the entries is the only way available to
do what you want. You can display all the options by creating a Type 2 or Type 3
join for the subform, not using the LinkMaster/LinkChild properties and
"manually" linking the subform to the main form. This is going to take up as
much room on your form as a simple multiselect listbox would.
Anything else you try will result in multiple number of attributes in the
WindowCondition field and you will have a hard time querying and reporting on
this field.
Maybe you need to look at the overall design of your system and determine why
you are running out of room on your form. Examine why you need so many controls
on your form.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:c6************@ID-98015.news.uni-berlin.de...
<kr**@dslextreme.com> wrote in message
news:10*************@corp.supernews.com... But what I want, is a group to contain one statement with many choices..
such as:
Window Condition:
Cloudy, Cracked, Loose Frame, Bad Sill
and I want all of these to be visible so the user does not have to scroll
through them.
I tried a listbox, and I expanded it so all the fields are visible, but it
takes up too much room
something like the looks of an 'OptionGroup' is what i am looking for.
If you want them NOT to be mutually exclusive, then you can't use an Option
Group. You could use a field per Option (not good design) or use a related
table where you can store anywhere from zero to "however many" and use a
subform to do the entries. The latter while a better table design will not lend
itself to using checkboxes all visible at the same time.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
