View Single Post
  #3  
Old July 14th 06, 08:28 PM posted to microsoft.public.outlook.program_forms
Gladys
external usenet poster
 
Posts: 12
Default 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




Ads