Yes No Data Type and Option Group

[Tom]

How do you set up an option group to do the following:

I have a field set as Yes/No data type and want to represent this field on a
form with an option group containing two options, Yes and No as option buttons.
I don't want either button to have the black dot in the center unless the user
actually selects an option. I created an option group and did not assign a
default value. I set the value for Yes as -1 and the value for No as 0. When the
form opens on a new record, there is a dot in the No option; I don't want a dot
in either option.

How do I set up the option group to not have a dot in either option for a new
record?

Thanks!

Tom

 

[Douglas J. Steele]

Are you getting a solid black dot, or a shaded gray dot? The shaded gray dot
means that no value's been assigned. Remember that no dot means false. If
you don't want any dot, you have no choice but to set its default to False.

 

[Bob Quintal]

How do you set up an option group to do the following:

I have a field set as Yes/No data type and want to represent this
field on a form with an option group containing two options, Yes
and No as option buttons. I don't want either button to have the
black dot in the center unless the user actually selects an option.
I created an option group and did not assign a default value. I set
the value for Yes as -1 and the value for No as 0. When the form
opens on a new record, there is a dot in the No option; I don't
want a dot in either option.

How do I set up the option group to not have a dot in either option
for a new record?

You need to change the4 yes/no field to a yes/no/maybe field. Since
Access doesn't have a yes/no/maybe data type use an integer. Or live
with the default no.

Bob