Microsoft Access check box formatting

I am trying to restrict my yes/no check box so that both cannot be checked
at the same time. Is this possible?

I think you want radio buttons instead.

krmckeown wrote:

> I am trying to restrict my yes/no check box so that both cannot be checked
> at the same time. Is this possible?

I am in the table, not the report. Am I approaching this wrong?

"Bob I" wrote:

> I think you want radio buttons instead.
>
> krmckeown wrote:
>
> > I am trying to restrict my yes/no check box so that both cannot be checked
> > at the same time. Is this possible?
>
>

In the table, a Check box is only a field, either ON or OFF, Yes or NO.
Perhaps you want to determine how many options you actually have. Is it
allowed to have both be NO? If they must have one OR the other, then ONE
box will suffice. If you want the field to be dependent on another
field, then you will need to set the fields using update query or other
means.

krmckeown wrote:

> I am in the table, not the report. Am I approaching this wrong?
>
> "Bob I" wrote:
>
>
>>I think you want radio buttons instead.
>>
>>krmckeown wrote:
>>
>>
>>>I am trying to restrict my yes/no check box so that both cannot be checked
>>>at the same time. Is this possible?
>>
>>

Thanks. I think that might be my answer.

"Bob I" wrote:

> In the table, a Check box is only a field, either ON or OFF, Yes or NO.
> Perhaps you want to determine how many options you actually have. Is it
> allowed to have both be NO? If they must have one OR the other, then ONE
> box will suffice. If you want the field to be dependent on another
> field, then you will need to set the fields using update query or other
> means.
>
> krmckeown wrote:
>
> > I am in the table, not the report. Am I approaching this wrong?
> >
> > "Bob I" wrote:
> >
> >
> >>I think you want radio buttons instead.
> >>
> >>krmckeown wrote:
> >>
> >>
> >>>I am trying to restrict my yes/no check box so that both cannot be checked
> >>>at the same time. Is this possible?
> >>
> >>
>
>

You're welcome, have a good day!

krmckeown wrote:

> Thanks. I think that might be my answer.
>
> "Bob I" wrote:
>
>
>>In the table, a Check box is only a field, either ON or OFF, Yes or NO.
>>Perhaps you want to determine how many options you actually have. Is it
>>allowed to have both be NO? If they must have one OR the other, then ONE
>>box will suffice. If you want the field to be dependent on another
>>field, then you will need to set the fields using update query or other
>> means.
>>
>>krmckeown wrote:
>>
>>
>>>I am in the table, not the report. Am I approaching this wrong?
>>>
>>>"Bob I" wrote:
>>>
>>>
>>>
>>>>I think you want radio buttons instead.
>>>>
>>>>krmckeown wrote:
>>>>
>>>>
>>>>
>>>>>I am trying to restrict my yes/no check box so that both cannot be checked
>>>>>at the same time. Is this possible?
>>>>
>>>>
>>