By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,501 Members | 2,850 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,501 IT Pros & Developers. It's quick & easy.

Multi Select in Option Groups

P: n/a
Hi guys,

I have a form that I am using option groups on..
how can i make each option group a multi select ?

thanks,
kevin

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Mon, 26 Apr 2004 20:03:18 GMT, <kr**@dslextreme.com> wrote:
Hi guys,

I have a form that I am using option groups on..
how can i make each option group a multi select ?

thanks,
kevin


You can't. An Option Group receives one value, regardless of how many
options there are within the group.

Without knowing more of what you are trying to accomplish, perhaps use
individual controls within a rectangle to approximate the appearance
of an option group, or a list box set to MultiSelect Simple or
Extended.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

P: n/a
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.
kevin

"fredg" <fg******@example.invalid> wrote in message
news:d0*****************************@40tude.net...
On Mon, 26 Apr 2004 20:03:18 GMT, <kr**@dslextreme.com> wrote:
Hi guys,

I have a form that I am using option groups on..
how can i make each option group a multi select ?

thanks,
kevin


You can't. An Option Group receives one value, regardless of how many
options there are within the group.

Without knowing more of what you are trying to accomplish, perhaps use
individual controls within a rectangle to approximate the appearance
of an option group, or a list box set to MultiSelect Simple or
Extended.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Nov 12 '05 #3

P: n/a
<kr**@dslextreme.com> wrote in
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.

create four separate checkboxes. Put a rectangle around them. Add
a label at the top of the rectangle.

All three control types are on the form design toolbox.

Bob Quintal

kevin

"fredg" <fg******@example.invalid> wrote in message
news:d0*****************************@40tude.net...
On Mon, 26 Apr 2004 20:03:18 GMT, <kr**@dslextreme.com>
wrote:
> Hi guys,
>
> I have a form that I am using option groups on..
> how can i make each option group a multi select ?
>
> thanks,
> kevin


You can't. An Option Group receives one value, regardless of
how many options there are within the group.

Without knowing more of what you are trying to accomplish,
perhaps use individual controls within a rectangle to
approximate the appearance of an option group, or a list box
set to MultiSelect Simple or Extended.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.



Nov 12 '05 #4

P: n/a
<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
Nov 12 '05 #5

P: n/a
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

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.