Validation

G

Guest

I want to validate field A: First has to be checked if field B is filled. If so field A must be filled.
 
S

Sue Mosher [MVP-Outlook]

Try:

([FieldA] <> "") OR ([FieldB] = "")

This validation expression will return True if FieldB is blank (in which
case you don't care what FieldA is) or if FieldA is filled.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



K. Lemans said:
I want to validate field A: First has to be checked if field B is filled.
If so field A must be filled.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A data validation question 1
Create Fillable PDF Forms With LibreOffice Writer 3
Field validation popup mesage 4
Required field on form 0
Validating 1
Auto fill not working 2
Task Form 0
Give error message 0

Top