Mailing Lists in Access

[Guest]

I want to use a query I have desinged to print a mailing list.

The table has first name, last name, etc. I have used the build function to
create single line items such as Name, and "City, ST ZIP". There are several
lines for Company, Department, and Office, that are sometimes blank. When I
print the report, I do not want the blank lines to show up.

For example the biggest address I have is this one:

Mr. Kay Ifekoya
Indiana Department of Environmental Management
Office of Land Quality
Leaking Underground Storage Tank Section (LUST)
100 N. Senate Aveneue
P.O. Box 6015
Indianapolis, Indiana 46206-6015

Which uses all the lines in the query, one of shorter ones looks like this
though:

Ohio CubCo, Inc.



11840 Valley View Road


Eden Prarie, MN 55344

I want to get rid of al the blank lines that do not have any information in
them when I print the mailing lables.

Thanks gang!

 

[Tom]

There is a property of the control called "CanShrink" on the Format tab. Set
it to True.

 

[Guest]

Thanks Tom, its these little things that make Access so great that I need to
learn to use. I am trying to convince my entire office to STOP using Excel
spreadsheets to maintain information and use just Access for DATA and Excel
for FINANCIAL information, but when I can't find an answer to a simple thing
like this its great to be able to turn to you guys here!

Larry