Reports - Hide Control (line) if field is null

[Seymore]

Hello!

I have two fields for address since many companies use two lines, one for street address and the other for department, suite, etc. I know in label wizard you can set up labels to skip blank lines so it doesn't leave a line space when there isn't data in the "Address2" field. However, I'm printing the return address on the top of the invoice and I can't get it to skip the line like it will do on the label.

Does anyone know how to get it to not show the blank line? Essentially I need it to move the city, ST Zip line up.

I've tried to deal with the 'can grow' and 'can shrink' properties, but these don't seem to help. I've also tried to compare the properties of the label that works with the report fields that don't and can't find any differences that work.

Any suggestions you can offer would be appreciated!

Thank you.

 

[Seymore]

While looking for other information on the site, I came across a post I was unable to find earlier. It told me that the field could not be overlapping and the whole row needed to be empty. As it happend, my field was overlapping and had other items on the row.

I corrected this and it worked!

Thank you bat17 for your help!