Question re yes/no fields and checkboxes


G

Guest

I want to add the option of yes or no on a form but I want to have two
checkboxes. One for Yes and one for No. Should I use a yes/no field in my
table and then create an option group in my form with a checkbox for yes and
a checkbox for no. I am not sure if the field in the table should be a yes/no
field. For example I would have a question: "Has patient had previous
treatment " and there would be checkbox for Yes and a checkbox for No. What
would be the best way to accomplish this. I am using Access 2003

Thanks in advance for any help.

Best regards,

Dee
 
Ad

Advertisements

J

John Vinson

I want to add the option of yes or no on a form but I want to have two
checkboxes. One for Yes and one for No. Should I use a yes/no field in my
table and then create an option group in my form with a checkbox for yes and
a checkbox for no. I am not sure if the field in the table should be a yes/no
field. For example I would have a question: "Has patient had previous
treatment " and there would be checkbox for Yes and a checkbox for No. What
would be the best way to accomplish this. I am using Access 2003

Thanks in advance for any help.

Best regards,

Dee
An Option Group control bound to the yes/no field will work. The value
of the Yes checkbox should be -1, the No checkbox 0. I believe the
toolbox option group wizard will do this for you.

John W. Vinson[MVP]
 

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