Hiding Fields in a Layout
I'm sure this topic is covered but I can't find it on here. I'm trying to hide 4-6 fields in a layout when a different field (the "Status" field) equals one OR another value. So two of the values out of six possible values in a drop down.
So I'm using Hide Field When: TableA:Status does not equal "Value1" OR "Value2"
I'm using the not equal to sign there of course because it's a hide when function. But it only hides when Value1 is met and it's like Value2 isn't even entered into the equation. I've tried this several different ways with parenthesis but it doesn't seem to help.
Any thoughts on how to hide when two value are NOT met but show when they are?