Yes/No checkbox in the form

J

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
 
C

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".
 
B

Bish

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top