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