Rule with Multiple Values

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

Guest

Hello,

I would like to add a rule to a field on my form. I have been successful
getting it to work with a single value (using Not Like), but cannot get it to
work with two values.

What the rules does:
Not allow either "n/a" or "no documents" to be entered into that field

Rule I wrote:
Not Like "n/a" OR "no documents"

The rule works in not allowing the "n/a" in the field, but does not work
when I type "no documents", which it still allows.

Thanks,
Rose
 
Not Like "n/a" OR Not Like "no documents"




You were saying it must meet one of the following:
1) The entry is not "n/a"
- Or -
2) The entry is "no documents"
 
Thanks!

RBear3 said:
Not Like "n/a" OR Not Like "no documents"




You were saying it must meet one of the following:
1) The entry is not "n/a"
- Or -
2) The entry is "no documents"



--
Hope that helps!

RBear3
..
Click to expand...
 
Hello,

I would like to add a rule to a field on my form. I have been successful
getting it to work with a single value (using Not Like), but cannot get it to
work with two values.

What the rules does:
Not allow either "n/a" or "no documents" to be entered into that field

Rule I wrote:
Not Like "n/a" OR "no documents"

The rule works in not allowing the "n/a" in the field, but does not work
when I type "no documents", which it still allows.

Thanks,
Rose
Click to expand...

The LIKE operator exists to provide wildcard functionality - * for matching
any string, ? for any character, etc. You aren't using wildcards so you don't
need LIKE.

I'd suggest either

<> "N/A" AND <> "no documents"

or

NOT IN("N/A", "no documents")

Of course this rule won't prevent the user from entering "N / A" or "Nothing
available" or "No docs provided" or any of the innumerable other such
circumlocutions...!

John W. Vinson [MVP]
 
Back
Top