Reputation: 165
I am trying to make a text box conditionally invisible by tying it to the value of adjacent revenue column.. I tried using the formula - if command.revenue > 5000 then crgreen else crnocolor , in the font formula editor but it is not working. Need help in doing this the right way. Thanks
Upvotes: 1
Views: 1306
Reputation: 32740
You should conditionally suppress the value instead of making it invisible; set the suppression formula for the textbox to
Command.Revenue > 5000
Upvotes: 1