|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 26th, 2008, 05:02 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Option Group
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? -- stacie 
|
|
#2
August 26th, 2008, 05:09 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Option Group
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? -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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? -- stacie
|
|
#3
August 26th, 2008, 05:21 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Option Group
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 "Klatuu" wrote: 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? -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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? -- stacie
|
|
#4
August 26th, 2008, 05:25 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Option Group
Stacie
Pardon my intrusion... a Yes/No field generally uses a checkbox, not an option group. Regards Jeff Boyce Microsoft Office/Access MVP "stacie" wrote in message ... 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 "Klatuu" wrote: 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? -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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? -- stacie
|
|
#5
August 26th, 2008, 05:28 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Option Group
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 -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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 "Klatuu" wrote: 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? -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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? -- stacie
|
|
#6
August 26th, 2008, 07:11 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Option Group
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. -- stacie "Klatuu" wrote: 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 -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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 "Klatuu" wrote: 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? -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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? -- stacie
|
|
#7
August 26th, 2008, 07:17 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Option Group
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. -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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. -- stacie "Klatuu" wrote: 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 -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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 "Klatuu" wrote: 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? -- Dave Hargis, Microsoft Access MVP "stacie" wrote: 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? -- stacie
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
