Don't Print Blank Field On A Report - HOW???

[WWRA]

I need to print a report, but eliminate blank fields.

For example, currently the report prints:
Name
Address 1
Address 2 ----------->Prints even if it is blank
City, State ZipCode

How can I print as follows when Address 2 is blank:
Name
Address 1
City, State Zip Code

Please note that I need to move the City, State Zip Code line up one line when Address 2 is blank.

As a Newbie, I'm really having a difficult time with this.

TIA for any suggestions.

 

[grnzbra]

You could use the Can shrink property to prevent the line from occurring in the absence of information. (If the label "Address 2" is included in the report, I don't think this will work directly. In that case, you might want to look into some kind of IIF statement to prevent its printing and then let the Can Shrink proprty work)