how do i create a formula in a form

[Guest]

I am creating a customised form in outlook, and within that form I am trying
to create a formula in a field that when a certain field contains a specific
string of characters or a phrase (from a drop down list), that another field
must be filled out.

 

[Sue Mosher [MVP-Outlook]]

How about providing a specific example and the field names? That's a lot
more fun to work with than Field1 and Field2.

 

[Guest]

The nature of the business is a horse stud farm, and i am trying to create a
"Booking Form" for mares visiting certain stallions. The fields i have
created are:

Stallion Name, Mare Name, Terms of Contract, Price and Notes

What i am trying to do is create a rule or formula to say that if the terms
field contains a specific term, then the notes field must contain text. To
be more specific: If the terms field (which is a drop down list) contains
"Free Nomination" then i want the corresponding Notes field to contain text,
thereby making the user put down a reason for giving away a free booking. I
hope this makes my problem a bit clearer!

I also seem to be having problems with printing now! but first things first.

Many Thanks

 

[Sue Mosher [MVP-Outlook]]

Validation formulas must evaluate to True if the data is "good" and False if
it's "bad." When you have dependent validations like this (one field
required if the other is a certain value), you usually need two expressions,
one for each field, e.g.:

([Terms of Contract] <> "Free Nomination") OR ([Notes] <> "")

If Notes is non-blank, the data is good. If Terms is anything other than
Free Nomination, the data is good.

Note that if the validation gets much more complex than this, I'd start
writing code. It's too hard to debug complicated formulas in teeny-tiny text
windows.