I have a text box with several fields in it. I would like to make a formula to supress one field inside the textbox if it is a certian value. I tried a 'formatting formula' but it didn't work:

if {field} = "SomeValue" then
    {field}="";

also tried.

if {..... Then
     {field}.supress;


neither worked. To be clear I only want to supress one field.


---------------------
| {field 1}          |
| {field 2}          |
| {field 3}          |
----------------------

Just hide field 2 if its = "xxx"