Yes/No checkbox in the form

  • Thread starter Thread starter Jordana
  • Start date Start date
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
 
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".
 
Use tyhe Option Group control. this creates a mutually
exclusive set of radio buttons, or check boxes.
 
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
 
Back
Top