Checkbox valdiation formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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