View Single Post
  #4  
Old September 28th 06, 03:21 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default validation help required

A validation formula for a custom Outlook form must return True if the data is "good" and False if it is not. I would probably try to handle this validation with code in the Iem_Send or Item_Write event handler. I am averse to complex validation formulas (or lots of them).

But if you want to give it a try, think of each checkbox field individually. Your data is "good" if the checkbox is not visible or if the checkbox field value is True. When is the checkbox not visible? When the option button field has a value other than the other corresponding to the checkbox. So, the formula for each checkbox would be something like this:

( [CheckBoxField1] = True) Or ([OptionButtonField] 1)

where I picked 1 out of the air as the value that the OptionButtonField has that makes the check box visible.

--
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

"Wayne" wrote in message ...
OL custom form

In my form I have a set of radio buttons all bound to the same field,
obviously having different values.

I have scripted checkboxes/text fields related to these radio buttons to
appear (using visibility) if a particular value is set to true. Now what I
want to do is when the radio button value is set to true, and a related
checkbox/text fields visibility is subsequently set to true, I want to
validate it to be either true/false for the checkbox, or make sure the text
field has data in it. So basically make sure the user acts on the new
visible fields.

Is this possible? It's a little complex for my current skills


Ads