 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming VBA / September 2006validation help required
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.?  SignatureSue 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 > In my form I have a set of radio buttons all bound to the same field, > obviously having different values. [quoted text clipped - 8 lines] > > Is this possible? It's a little complex for my current skills OL custom form > Is this a VBA userform or an Outlook custom form.? > [quoted text clipped - 10 lines] > > > > Is this possible? It's a little complex for my current skills 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. SignatureSue 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 > OL custom form > [quoted text clipped - 10 lines] >> > >> > Is this possible? It's a little complex for my current skills |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.