Check box a required field?

stafire_18

Board Regular
Joined
Dec 8, 2004
Messages
162
Im trying to change the properties of a check box to be a required field before saving a record. I change the Required="yes" but I am still allowed to save the record without having to check mark that box. I want to have to check mark it.

any ideas.?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,351
Office Version
  1. 365
Platform
  1. Windows
A checkbox has 2 values - True/False.

By setting Required to yes all you are doing is forcing the user to enter either of those values, not True which is the value when the box is checked.
 

stafire_18

Board Regular
Joined
Dec 8, 2004
Messages
162
that's what i gathered what was happening. do you know of any way i can get around it? maybe a value list or field list? Then just enter "NO" as the only option available so they have to select it?
 

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
Have you tried setting the Default Value of the CheckBox to Null? When the user tries to move off of that record, you can check If isnull(YourCheckbox) then .....

You may have to remove the Required = Yes at the table level for this to work properly... otherwise, the user may not be able to cancel and exit without entering something into the checkbox, which you don't want either.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,128
Messages
5,857,531
Members
431,884
Latest member
Gcmoore63

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
Top