|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
November 8th 06, 05:07 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
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 ] '' ) 
|
|
#2
November 9th 06, 12:46 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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 ] '' )
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Address book won't link to contacts even after checking checkbox | UB | Outlook - Using Contacts | 1 | October 9th 06 02:56 AM |
| Address book won't link to contacts even after checking checkbox | UB | Outlook - Using Contacts | 0 | October 9th 06 02:07 AM |
| outlook checkbox merge | adubb | Outlook - Using Forms | 1 | May 27th 06 02:14 PM |
| if checkbox is checked then... | andy | Outlook - Using Forms | 3 | April 5th 06 09:45 PM |
| Using a Checkbox in Outlook Form Designer | Frank R | Outlook - Using Forms | 3 | March 29th 06 03:47 PM |
Hybrid Mode
