In a database I am working on for my church I need to print address labels. I am using the version of Crystal Reports that shipped with VB6 and it works fine with one exception. Some of my address have both address1 and address2. Most don't. If I set up Crystal reports to use both address lines and there is data for only one then my labels print with a blank line. Is there a way to have it automatically suppress a line that has no data?

Rev. Michael L. Burns