Checkbox valdiation formula
 

I have two checkboxes on a custom form, 'yes' and 'no'. I want to create
formula that says if neither yes or no is selected then a validation message
will appear asking for one of the boxes to be selected. This is how my
formula looks now:

Emergency Training CheckBox = yes
Emergency Training No CheckBox= no

IIf( [Emergency Training CheckBox] =false and [Emergency Training No
CheckBox ] =false , [Emergency Training CheckBox] or [Emergency Training No
CheckBox ] '' )

Checkbox valdiation formula
 

A validation formula must return True if the data is "good" and False if it is not. In your scenario, the data is "good" if either field has a True value:

([Field 1] = True) OR ([Field 2] = True)

Plug your field names (not control names) into that.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Aggie G" wrote in message ...
I have two checkboxes on a custom form, 'yes' and 'no'. I want to create
formula that says if neither yes or no is selected then a validation message
will appear asking for one of the boxes to be selected. This is how my
formula looks now:

Emergency Training CheckBox = yes
Emergency Training No CheckBox= no

IIf( [Emergency Training CheckBox] =false and [Emergency Training No
CheckBox ] =false , [Emergency Training CheckBox] or [Emergency Training No
CheckBox ] '' )