Check Boxes

Jackblack1

Active Member
Joined
Feb 10, 2004
Messages
266
I have created 2 check boxes on a form for Yes and No answers, the problem is that the wizard does not appear so that I can give a it a value any ideas?

The value I want to give it is 1 and 2: 1=yes, 2=No. So that it is stored in the table.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
By default, checkboxes store data as -1 for Yes and 0 for No.
As long as you have a Control Source to store the results, that's what you get.

Denis
 
Upvote 0
I have used the wizard before to set up option values these were established by using a the wizard. The option values I have are 1=yes and 2=no. How can I set it up so that I have to buttons yes and no on the same form
 
Upvote 0
With Wizards turned ON, drag an Option Group onto the form in Design View. Follow the steps and you'll be able to do what you need.
I'd suggest using option buttons rather than check boxes for the yes/no -- less confusing for the users.

Denis
 
Upvote 0

Forum statistics

Threads
1,221,860
Messages
6,162,479
Members
451,769
Latest member
adyapratama

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top