Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Hope it helps!!
Try this:
=if($(vReport) = 'SH07' , 1,-1)
Hope it Hepls!!
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' ... ?
In the Show Conditional on the Layout tab put
vReport = SH07
Stephen
Thanks, works great. I was making it more complicated then it needed to be.