Can anybody tell me what’s the relation betweenhide when and hide if formula is true on the property of a field? Are they an “AND” or “OR” relation? Or one overrides another?
thanks.
Subject: hide when and hide if formula is true
They compliment each other. The formula is there to express complex conditions that cannot be expressed by the simple check boxes.
When both are used, they OR each other.
Subject: hide when and hide if formula is true
Hide when choices overide Hide if formula.
Subject: RE: hide when and hide if formula is true
Either one is sufficient to hide the paragraph - thus they are an OR.
e.g. Hide when Reading OR Status = “Closed”
Subject: RE: hide when and hide if formula is true
I disagree as I have interpreted the question:
If you have selected to Hide When the document is being read and also entered a formula to hide when Field1=“”, if in read mode the Hide when will ALWAYS win if Field1 !=“”.
Subject: RE: hide when and hide if formula is true
Yes, we are saying the same thing. If either the first test OR the second test is true, the field will be hidden. It does not matter which one wins - either is sufficient to hide the field.
Subject: RE: hide when and hide if formula is true
I think we are splitting hairs but that is ok:-).
Subject: RE: hide when and hide if formula is true
I agree with Graham. I just tested and they donot override each other.