How to Eliminate Blank Lines in a Report?

[TWD]

Hi everyone,



I have an access report that is a recreation of a letter. My table contains each person's mailing address with a separate field for each address line.

My problem is if I place each address line fields on the report underneath each other, there will be blank lines because not everyone has multiple address lines.

Ex: DAVID GEORGE
123 EAST WESTBROOK
APT #32
CITY, STATE ZIP


But the next record could look like this because they don't have more than one address line:

DAVID STILLS
123 HOLDEN DR

CITY, STATE ZIP


I don't want the blank line on Holden. Is there any way to do this?

[amrut]

Try this -
Add a textbox to the report and set its control source to all the address fields separated by chr(13) & chr(10)
Like [AddressLine1] & chr(13) & chr(10) & [AddressLine2]. Set its cangrow property to yes. Hide your all address fields on report with height set to 0