Making a neat list of addresses

[GalleryOperator]

I'm trying to make a neat list of our gallery mailing list. I have all the
usual address fields ([First Name], [Last Name], [Company], [Address1], etc.)
& cannot figure out how to print a report without gaps:

John Smith

123 Ash Lane

Chicago, IL 60610

This would be an example if the [Company] & [Address2] fields were null.
What I would prefer is something more readable, like:

John Smith
123 Ash Lane
Chicago, IL 60610

Thanks much!

 

[Roger Carlson]

Look at the CanShrink property of the controls on your Report.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[GalleryOperator]

Thanks, Roger!

Look at the CanShrink property of the controls on your Report.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

I'm trying to make a neat list of our gallery mailing list. I have all the
usual address fields ([First Name], [Last Name], [Company], [Address1], etc.)
& cannot figure out how to print a report without gaps:

John Smith

123 Ash Lane

Chicago, IL 60610

This would be an example if the [Company] & [Address2] fields were null.
What I would prefer is something more readable, like:

John Smith
123 Ash Lane
Chicago, IL 60610

Thanks much!

 

[TerryC]

John,

Roger's response is the common method for resolving your issue with gaps.
Alternatively you can use the "+" (plus) sign. This is the same as an "&"
(ampersand) except it only activates if there is data in the field. This can
be handy where you have [title] [first name] and a [last name] fields which
are not all populated.

[title] & " " & [first name] & " " & [last name] will result in:
Mr John Smith (if all fields are populated)
John Smith ([title] field unpopulated - note the leading space)

([title] + " ") & ([first name] + " ") & [last name] will result in:
Mr John Smith (or)
John Smith (no leading space)

The following example is from a multiline address block (with only one name
field):


[name] & (Chr(13)+Chr(10)+[address line 1]) & (Chr(13)+Chr(10)+[address line
2]) & (Chr(13)+Chr(10) & [locality] & " " & [state] & " " & [postcode])

The Chr(13) and Chr(10) are a carriage return and linefeed to create the
next address line. For some strange reason they need to be in the order shown
13 first.

This example will rersult in no blank lines.

HTH

Terry