Suppress if Null possible? 1

[TechUser23]

Two Fields:

Phone1
Phone1Type

I put a text box into my report and put in Phone1 then a "(" and then Phone1Type then a ")"

If the report is null its just putting a "()" in my report ... can I suppress if Null somehow?

 

[lbass]

Create a formula instead of using a text box:

if isnull({table.phone1}) then "" else
if isnull({table.phonetype}) then
{table.phone1} else
{table.phone1}+"( "+{table.phonetype}+")"

-LB

 

[TechUser23]

You saved me again ... you need to write a book with all your knowledge. Its amazing! Thanks a million ... saved my day.