A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

validation help required



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 27th 06, 03:56 AM posted to microsoft.public.outlook.program_vba
Wayne
external usenet poster
 
Posts: 61
Default validation 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
  #2  
Old September 27th 06, 01:55 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default validation help required

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  
Old September 28th 06, 12:30 AM posted to microsoft.public.outlook.program_vba
Wayne
external usenet poster
 
Posts: 61
Default validation help required

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


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 07:09 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.