how to suppress field inside text object

[HRHK]

I have two fields (Supplier_desc & item_desc) inside Text Object.
If Supplier is "Cuba" or has any following conditions, how can I suppress just the supplier_desc field and not item desc in the text object? Thanks.


The Text object is in detail section. I right clicked the text object,
right clicked and the formula is in the Suppress button.

{t_supplier.supplier_desc}= "Cuba" or
({t_item.src_id}= 1 and {t_item.item_desc} <> "Banana") or
({t_item.src_id}= 1 and {t_item.item_desc} <> "Cigar") or
({t_item.src_id}= 1 and {t_item.item_desc} <> "SugarCane")

 

[lbass]

Replace {Supplier_Desc} in the text box with a formula:

if {t_supplier.supplier_desc}= "Cuba" or
({t_item.src_id}= 1 and {t_item.item_desc} <> "Banana") or
({t_item.src_id}= 1 and {t_item.item_desc} <> "Cigar") or
({t_item.src_id}= 1 and {t_item.item_desc} <> "SugarCane")
then "" else {Supplier_Desc}

-LB

 

[HRHK]

I tookout supplier_desc field from text object and used the above formula. A msgbox shows "Formula result must be boolean". Thanks LB

 

[HRHK]

Pls ignore previous post, I forgot to use it as formula. Thanks.