Checkbox valdiation formula

[Aggie G]

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 ] <> '' )

 

[Sue Mosher [MVP-Outlook]]

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers