![]() |
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
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Is this a VBA userform or an Outlook custom form.?
-- 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 ... 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 |
#3
|
|||
|
|||
![]()
OL custom form
"Sue Mosher [MVP-Outlook]" wrote: Is this a VBA userform or an Outlook custom form.? -- 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 ... 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 |
#4
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with creating a validation | Gladys | Outlook - Using Forms | 7 | July 15th 06 02:16 AM |
Data Validation | [email protected] | Outlook - Using Forms | 1 | May 9th 06 09:19 PM |
Data Validation | broknlgs24 | Outlook - Using Forms | 0 | May 9th 06 08:20 PM |
Validation | ~KO | Outlook - Using Forms | 9 | February 22nd 06 09:51 PM |
Creating a validation formula | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 06:26 PM |