Eliminate blank line in list

[KathyRingwood]

Hi: I have created a report that creates a class roster. Sometimes, one of the fields (organization) contains no data. I would like to eliminate the blank line this produces in the roster but have not been able to figure out how to do this. Here's my code for the roster:
=Trim([last_name]& ","&[first_name]& "," &[degree])
organization_name
=Trim([City]& "," &[user_state])

Thanks for any help you may be able to offer.

--Kathy

 

[dhookom]

Have you tried setting the text box Can Shrink property to Yes?

Duane
Hook'D on Access
MS Access MVP