validation help required

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

Guest

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
 
Is this a VBA userform or an Outlook custom form.?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

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

Sue Mosher said:
Is this a VBA userform or an Outlook custom form.?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Click to expand...
 
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

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