What is the syntax for an 'if' statement in a conditional?

[#1]

Hello,

I have a text box that I only want displayed if a variable is set to 'SH07'. I attempted this: =if(vReport='SH07',1,-1) but it does not work.  No matter what the variable is set to the text box is always displayed.  Anyone know the correct syntax?

Thanks,

Tyler

[#2]

Try this:

Hope it helps!!

[#3]

Try this:

=if($(vReport) = 'SH07' , 1,-1)

Hope it Hepls!!

[#4]

Still no dice unfortunately, seems to always use the 'else'.  If I change it to =if($(vReport) = 'SH07',1,0) then it hides if vReport is set to 'SH09' or 'SH07' ... ?

[#5 · Accepted solution]

In the Show Conditional on the Layout tab put

vReport = SH07

Stephen

[#6]

Thanks, works great.  I was making it more complicated then it needed to be.