Option Group selection blank

  • Thread starter Thread starter LMB
  • Start date Start date
L

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
 
LMB said:
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?
Click to expand...

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 said:
Dirk,

That worked! How come?
Click to expand...

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 said:
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)
Click to expand...

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

Linda
 
LMB said:
Thank-you so much...I really like the font on your website, I can
read it without my stupid new glasses!
Click to expand...

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. :-)
 
Back
Top