I am wondering if there is a calculation to hide a field when 5 other fields are either empty or equal 0. In other words, Field A on my layout should be hidden when Field B is empty or 0 and Field C is empty or 0 and Field D is empty or 0 and Field E is empty or 0 and Field F is empty or 0. If this is possible, I have not been able to figure out how to properly write the calculation.

Any feedback is much appreciated!

Thanks,

Carrie

Hi,

I think you're looking for "hide when" ...

IsEmpty (

fieldB & fieldC & fieldD & fieldE & fieldF

)

it tests if the concatenation of all the fields is empty (ergo, all fields are empty).

Or, if they are number fields ...

"hide when" (fieldB + fieldC + fieldD + fieldE + fieldF) = 0