Field not required

[Art]

I am having a brain gas bubble (being politically correct).

I have a field that I want to say is not required if another field is not
blank. In other words, make field 2 required if field 1 is blank. And
conversely, if field 1 is not blank, fields 2 is not required.

Rule? Validation?

 

[S.Y.M. Wong-A-Ton]

Add data validation on field2 with the following two conditions:

field1 is blank
AND
field2 is blank

 

[Art]

Thanks

Sometimes the brain just fries out.

Add data validation on field2 with the following two conditions:

field1 is blank
AND
field2 is blank

 

[S.Y.M. Wong-A-Ton]

No worries.
---
S.Y.M. Wong-A-Ton

Thanks

Sometimes the brain just fries out.