Option Group

[Guest]

I have a field called "Blueprint" that is a yes/no. All I want to do on my
form is in the option group is have a Yes and a No check box but it must
attach the answer to the Blueprint field.

I used the wizard for the option group, typed my fields Yes and No, said to
attach answer to Blueprints, but it didn't work. I know this should be
simple, but what am I doing wrong.

Thanks.

 

[Jeff Boyce]

If the underlying data field is of datatype Yes/No, there are two valid
values. A "0" represents no/false, and (in Access/Jet) a "-1" represents
yes/true.

An option group has values starting with 1, 2, ... so your option group
"check boxes" are telling the option group (which it sounds like you bound
to the Yes/No field) a value of 1 or 2.

If you want to know/record whether a Blueprint is available, why not just
use a single checkbox, bound to the underlying field. If checked, the
Blueprint is available. If not checked, it isn't. And this should solve
the problem of the disconnect between what the control is sending and what
the underlying field needs to see.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Douglas J Steele]

I don't really understand why you'd want an Option Group for a yes/no
situation. A Check Box is the normal way: checked means Yes, and unchecked
means No.