G Guest Mar 8, 2004 #1 I want to validate field A: First has to be checked if field B is filled. If so field A must be filled.
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] Mar 9, 2004 #2 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. Click to expand... If so field A must be filled.
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. Click to expand... If so field A must be filled.