SHOW IF Expression not working I am trying t...

[Jason_Spicer]

SHOW IF Expression not working

I am trying to do a SHOW IF expression to show columns if they do not equal a value in a ENUM column in the table.

The expressions by themselves work with the <> value, but as soon as I wrap them together with an OR expression, they don’t work and show the column.

But, if I keep the combined expression and change the <> to = (which is the opposite of what I am trying to do), the expression works and hides the column unless either of the two values are chosen. Shouldn’t it work with the <> too?

Here is my expression with the working combined

=OR([Room/Item Name]=“Roof”, [Room/Item Name]=“Siding”)

Here is what I want it to do

=OR([Room/Item Name]<>“Roof”, [Room/Item Name]<>“Siding”)

They work like this

[Room/Item Name]<>“Siding”

but not wrapped up in OR.

Am I just missing something and my brain is not seeing it?

Thank you for any help