Option Groups

[JB]

Hello
I created an Option Group with the Wizard. Followed the instructions.
I want 2 checkboxes or radio buttons one 'Yes' and the other 'No'. with no
default.
It is bound to a field in the underlying table.
But when I click any of them in form view nothing happens. Neither the radio
buttons or the check boxes.
What am I doing wrong?
The table's fields data type for these controls is Yes/No.

Thank you
Jen

 

[fredg]

Hello
I created an Option Group with the Wizard. Followed the instructions.
I want 2 checkboxes or radio buttons one 'Yes' and the other 'No'. with no
default.
It is bound to a field in the underlying table.
But when I click any of them in form view nothing happens. Neither the radio
buttons or the check boxes.
What am I doing wrong?
The table's fields data type for these controls is Yes/No.

Thank you
Jen

Re: The table's fields data type for these controls is Yes/No.

1) If there are only 2 options available (for Yes or No), why do you
need an option group with the 2 buttons? If the Yes button is NOT
selected, then the option group value must be No (or vice versa).
Instead of an Option Group, just use a single Check box. If it is
checked, that means Yes and a value of -1 is saved in the bound table
field. If it is not checked, that means No, and a value of 0 is saved
in the table (or vice versa).

2) If you still wish to use an Option Group, then you must first
change the datatype of the field in the table from Yes/No datatype to
Number datatype, Integer field size.
Then you can use an Option Group with the 2 options, Yes or No, bound
to this field. However, the value that will be saved in the table will
be 1 or 2, not -1 or 0.

 

[JB]

Sorry I clicked on Reply Group instead of New. Didn't meant to continue on
this tread
Jen

 

[JB]

Thank you Fred. That's so helpful.
I too thought it logical just to use the check box for yes but it was
requested to have both yes and no.
I'll try and persuade the users to go with your suggestion
Thank you
Jen

 

[fredg]

Thank you Fred. That's so helpful.
I too thought it logical just to use the check box for yes but it was
requested to have both yes and no.
I'll try and persuade the users to go with your suggestion
Thank you
Jen

You can use the Option Group with the 2 buttons. It's just that you
cannot use a Yes/No field in the table to store the selected value, as
a Yes/No field stores only -1 or 0, while and Option Group stores 1,
2, 3, 4, etc. depending upon how many options you have.
For me, a Check Box is easier. I wouldn't start WWIII over this if it
makes the user's life easier. Just change the field's datatype and
field size as mentioned previously. You will probably also want to
have one of the options as the default.

 

[John W. Vinson]

You can use the Option Group with the 2 buttons. It's just that you
cannot use a Yes/No field in the table to store the selected value, as
a Yes/No field stores only -1 or 0, while and Option Group stores 1,
2, 3, 4, etc. depending upon how many options you have.

Well... actually you can define the values of the two buttons in an Option
Group to be 0 and -1 (or any desired integers).