Validation Rules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How does one set up a validation rule so that a user cannot insert certain
words into a text box. The field is setup up as a required field.
 
How about <>"banana" or "Plum"

where <> means not and the text string must be enclosed in
quote marks............

Try it with one text string and see if it works.....dont
forget to use a sensible validation message

Then see can you graduate to the OR level

If it works with one OR it will work with two or more

Regards

Jim Dublin
 
Back
Top