Eliminate blank space in report...

[WiscCard]

I am using a report to create a mailing letter. I have to use the report function because I need the letter to include a subreport of different data from another table.
I have tried using the Can Shrink in properties to close up blank space, but it is not working. My address fields are:
Name
AlternateName
ADDRESS
ADD2
ADD3
CITY STATE ZIP
Not every entry wil have alternatename, add2, add3. I need those horizontal spaces to be closed up as well as blank space between city and state to close up much like Word would with a mail merge.

 

[CT Witter]

Check out

Eliminating unwanted blank lines in labels and reports
http://office.microsoft.com/en-us/access/HA011494721033.aspx

HTH,
CT