Yes/No checkbox in the form

[Jordana]

I have a field called action in a table, to check if
something requires action the user must check the box. The
field in the table is defined as a yes/no field, but when
I am designing the form, I would like to see both yes and
no check boxes is there a way to do that? and import the
result back to the table.?

Thanks,

Jordana

[Cheryl Fischer]

You could use the OptionGroup control on your form instead of a single
CheckBox control. When using the wizard to create your OptionGroup, set
the labels as 'Yes' and 'No'; the default value for 'Yes' should be -1 and
for 'No', the default value should be 0. You can format the OptionGroup to
display as Check Boxes or Radio Buttons.

Bind this OptionGroup control to your table's Yes/No field and you won't
need to "import the result back to the table".

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

"Jordana" <jordanahM@hotmail.com> wrote in message
news:0ba701c3582d$0ada09e0$a301280a@phx.gbl...

> I have a field called action in a table, to check if
> something requires action the user must check the box. The
> field in the table is defined as a yes/no field, but when
> I am designing the form, I would like to see both yes and
> no check boxes is there a way to do that? and import the
> result back to the table.?
>
> Thanks,
>
> Jordana
>

[Bish]

Use tyhe Option Group control. this creates a mutually
exclusive set of radio buttons, or check boxes.

>-----Original Message-----
>I have a field called action in a table, to check if
>something requires action the user must check the box.

The

>field in the table is defined as a yes/no field, but when
>I am designing the form, I would like to see both yes and
>no check boxes is there a way to do that? and import the
>result back to the table.?
>
>Thanks,
>
>Jordana
>
>.
>

[jordana]

Thanks, I actually did that and when I open the table to
see the value in the field it is 0 or -1 instead of yes/no
how can I format the the values to give me the option name
rather then the value number?

Thanks again,

Jordana

>-----Original Message-----
>You could use the OptionGroup control on your form

instead of a single

>CheckBox control. When using the wizard to create your

OptionGroup, set

>the labels as 'Yes' and 'No'; the default value for 'Yes'

should be -1 and

>for 'No', the default value should be 0. You can format

the OptionGroup to

>display as Check Boxes or Radio Buttons.
>
>Bind this OptionGroup control to your table's Yes/No

field and you won't

>need to "import the result back to the table".
>
>--
>Cheryl Fischer
>Law/Sys Associates
>Houston, TX
>
>"Jordana" <jordanahM@hotmail.com> wrote in message
>news:0ba701c3582d$0ada09e0$a301280a@phx.gbl...

>> I have a field called action in a table, to check if
>> something requires action the user must check the box.

The

>> field in the table is defined as a yes/no field, but

when

>> I am designing the form, I would like to see both yes

and

>> no check boxes is there a way to do that? and import the
>> result back to the table.?
>>
>> Thanks,
>>
>> Jordana
>>

>
>
>.
>