|
| 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
July 14th 06, 07:08 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Help with creating a validation
In this form I am working on, I have two fields: [Country] (which is a drop
down combo box) and [Other country], a text field which will require input if the country of choice is not available for the user. For example, if the user chooses "other" from the drop down list of [country], they will need to specify the country name in the [other country] text field. I tried to use the following formula in the validation tab: ([country] "other") OR ([other country] "") but I got an "error in validation text formula for 'other country' -- illegal right operand for IN". What did i do wrong? I hope someone can help me out so I can stop banging my head against the wall. Thanks 
|
| Ads |
|
#2
July 14th 06, 07:14 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Help with creating a validation
Do you also have validation text that displays a message to the user? (the 2nd formula box on the Validation tab) I think that's what this message is referring to.
-- 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 "Gladys" wrote in message ... In this form I am working on, I have two fields: [Country] (which is a drop down combo box) and [Other country], a text field which will require input if the country of choice is not available for the user. For example, if the user chooses "other" from the drop down list of [country], they will need to specify the country name in the [other country] text field. I tried to use the following formula in the validation tab: ([country] "other") OR ([other country] "") but I got an "error in validation text formula for 'other country' -- illegal right operand for IN". What did i do wrong? I hope someone can help me out so I can stop banging my head against the wall. Thanks
|
|
#3
July 14th 06, 08:28 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Help with creating a validation
Thanks. I played around with the message text and realised that if my message
got too long, this error message pops up. Do you know if the message text is restricted to a certain number of letters? Also, the formula I've used: ([country] "other") OR ([other country] "") didn't work. I tested the form in 'run this form' mode and I chose 'other' from the[ country] drop down list but the form did not prompt me to enter something in the [other country] text field. Is there is mistake with this formula? Thanks alot! "Sue Mosher [MVP-Outlook]" wrote: Do you also have validation text that displays a message to the user? (the 2nd formula box on the Validation tab) I think that's what this message is referring to. -- 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 "Gladys" wrote in message ... In this form I am working on, I have two fields: [Country] (which is a drop down combo box) and [Other country], a text field which will require input if the country of choice is not available for the user. For example, if the user chooses "other" from the drop down list of [country], they will need to specify the country name in the [other country] text field. I tried to use the following formula in the validation tab: ([country] "other") OR ([other country] "") but I got an "error in validation text formula for 'other country' -- illegal right operand for IN". What did i do wrong? I hope someone can help me out so I can stop banging my head against the wall. Thanks
|
|
#4
July 14th 06, 08:53 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Help with creating a validation
Thanks. I played around with the message text and realised that if my message
got too long, this error message pops up. Do you know if the message text is restricted to a certain number of letters? I think you've already answered that question through your own experimentation. Trust your results! Also, the formula I've used: ([country] "other") OR ([other country] "") didn't work. I tested the form in 'run this form' mode and I chose 'other' from the[ country] drop down list but the form did not prompt me to enter something in the [other country] text field. Is there is mistake with this formula? Outlook will prompt only when you save the item with Country = "other" and Other Country blank. -- 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 "Gladys" wrote in message ... Thanks. I played around with the message text and realised that if my message got too long, this error message pops up. Do you know if the message text is restricted to a certain number of letters? Also, the formula I've used: ([country] "other") OR ([other country] "") didn't work. I tested the form in 'run this form' mode and I chose 'other' from the[ country] drop down list but the form did not prompt me to enter something in the [other country] text field. Is there is mistake with this formula?
|
|
#5
July 14th 06, 10:56 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Help with creating a validation
One last question: Can I do wrap text in the text fields? It is so irritating
to scroll horizontally. Thanks! "Sue Mosher [MVP-Outlook]" wrote: Thanks. I played around with the message text and realised that if my message got too long, this error message pops up. Do you know if the message text is restricted to a certain number of letters? I think you've already answered that question through your own experimentation. Trust your results! Also, the formula I've used: ([country] "other") OR ([other country] "") didn't work. I tested the form in 'run this form' mode and I chose 'other' from the[ country] drop down list but the form did not prompt me to enter something in the [other country] text field. Is there is mistake with this formula? Outlook will prompt only when you save the item with Country = "other" and Other Country blank. -- 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 "Gladys" wrote in message ... Thanks. I played around with the message text and realised that if my message got too long, this error message pops up. Do you know if the message text is restricted to a certain number of letters? Also, the formula I've used: ([country] "other") OR ([other country] "") didn't work. I tested the form in 'run this form' mode and I chose 'other' from the[ country] drop down list but the form did not prompt me to enter something in the [other country] text field. Is there is mistake with this formula?
|
|
#6
July 14th 06, 11:27 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Help with creating a validation
Look for the Multiline setting on each control's Properties or Advanced Properties dialog.
-- 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 "Gladys" wrote in message ... One last question: Can I do wrap text in the text fields? It is so irritating to scroll horizontally. Thanks!
|
|
#7
July 15th 06, 12:24 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Help with creating a validation
Thank you very very much! You're my lifesaver!
If i've got a checkbox with yes/no option [Is this a renewal ?] with a text field beside it [please enter new contract number if it is a renewal], can I use the following formula to force the user to enter a number in the text field? ([Is this a renewal ?] "yes") OR ([please enter new contract number]"")
|
|
#8
July 15th 06, 01:16 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Help with creating a validation
Close but not quite. A Yes/No property can have two values -- True or False -- and those are constants, not string literals, so no quote marks around them. See if you can finish the formula, given that info.
-- 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 "Gladys" wrote in message ... Thank you very very much! You're my lifesaver! If i've got a checkbox with yes/no option [Is this a renewal ?] with a text field beside it [please enter new contract number if it is a renewal], can I use the following formula to force the user to enter a number in the text field? ([Is this a renewal ?] "yes") OR ([please enter new contract number]"")
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating a validation formula in Outlook 2003 | Gladys | Outlook - Using Forms | 1 | July 14th 06 02:51 AM |
| Data Validation | [email protected] | Outlook - Using Forms | 1 | May 9th 06 08:19 PM |
| Data Validation | broknlgs24 | Outlook - Using Forms | 0 | May 9th 06 07:20 PM |
| Validation | ~KO | Outlook - Using Forms | 9 | February 22nd 06 08:51 PM |
| Creating a validation formula | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 05:26 PM |
Linear Mode
