Option Group selection blank

[LMB]

Hi Guys,

I am using Access 2000. I put an option group on my form that with the
control source a y/n field. When I click in the circle for yes, the table
field is updated but the circle is not filled in on the form so both the yes
and no field are white. How can I get this to fill in when clicked?

Thanks,
Linda

 

[Dirk Goldgar]

Hi Guys,

I am using Access 2000. I put an option group on my form that with
the control source a y/n field. When I click in the circle for yes,
the table field is updated but the circle is not filled in on the
form so both the yes and no field are white. How can I get this to
fill in when clicked?

What's in the OptionValue properties of the two radio buttons? Since
you have bound this to a boolean (yes/no) field, I'm thinking they
should be -1 for the Yes button, 0 for the No button.

 

[LMB]

Oh..Radio Buttons :^)

Yes = 1
No = 2

Thanks,
Linda

 

[Dirk Goldgar]

Oh..Radio Buttons :^)

Yes = 1
No = 2

Thanks,
Linda

Change them to

Yes = -1
No = 0

 

[LMB]

Change them to

Yes = -1
No = 0


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Dirk,

That worked! How come?

Thanks,
Linda

 

[Dirk Goldgar]

Dirk,

That worked! How come?

Because the option group is bound to a boolean (yes/no) field, and such
a field can only store the values -1 (True) and 0 (False). When you had
the option values set to 1 and 2, I think that whichever button you
clicked, the value would be converted to -1 (since all non-zero values
are interpreted as True) and stored that way; however, when it comes to
displaying the value of the field, neither -1 nor 0 matches the values
assigned to your option buttons, so neither button is shown as
selected.

 

[LMB]

Because the option group is bound to a boolean (yes/no) field, and such
a field can only store the values -1 (True) and 0 (False). When you had
the option values set to 1 and 2, I think that whichever button you
clicked, the value would be converted to -1 (since all non-zero values
are interpreted as True) and stored that way; however, when it comes to
displaying the value of the field, neither -1 nor 0 matches the values
assigned to your option buttons, so neither button is shown as
selected.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thank-you so much...I really like the font on your website, I can read it
without my stupid new glasses!

Linda

 

[Dirk Goldgar]

Thank-you so much...I really like the font on your website, I can
read it without my stupid new glasses!

You're welcome. And thanks for the compliment -- as it says in the web
design section, we do try to make pages that are easy to use.