Option Group

  • Thread starter Thread starter stacie
  • Start date Start date
S

stacie

I set up an option group on a form. However, I am unable to select eithier
of the items in the option box. Any ideas why this is happening?
 
More detail, please.
Is the Option Group a bound control?
If so, what is the data type of the field it is bound to?
What are the Option Values specified for the option buttons?
Is there a Default Value for the Option Group?
What happens when you click on either of the buttons?
 
The option group is a bound control to a field in the table. The datatype
field is yes/no. I have no default values and nothing happens whenever I try
to specify one of my options.
 
Stacie

Pardon my intrusion... a Yes/No field generally uses a checkbox, not an
option group.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
My guess is the option values for your option group buttons are not correct.
The Yes or True button's value should be -1 and the No or False button's
value should be 0

A Yes/No (Boolean) field can accept only Null, 0, or -1
 
I figured it out. The field in the table is set to yes/no boxes and it
should have been set to text.

Thanks to all.
 
Really?
Why would you be using a text data type with a control that is designed for
and used integer data?
As Jeff pointed out, if it is a Yes or No situation, a Check Box is normally
used for that. I did not comment because I can see where for style
considerations you might want to use an option group with two options, but to
use an option group with a text data type and two possible values is even
more unusual.
 
Back
Top