Making a neat list of addresses

G

Guest

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!
 
G

Guest

Thanks, Roger!

Roger Carlson said:
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 said:
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!
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top