How to disable textbox control from crystal report if it has no value ?

Question

hi, i have one textbox which is displaying Address2 , if it has value then no problem, but if it has no value then it displays blank space at that portion of the report, my problem is i dont want to put any blank space if the text box has blank value for the addrees2 field.

please let me know if any solution for the same.

thanks in advance manish parmar.

Answer 1

Right click the textbox and select Format Field

Select the Common tab

Click the Formula button next to the Suppress

Change the formula to something like

IsNull({REPORT;1.Address2}) or {REPORT;1.Address2} = ""

Click Save and Close

That should about do it.