Phone list report with multiple columns

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hello,

Don't know how to do a lot of code, but is there any way
to easily create a phone list that the contact infomation
is "not" on a single line? I want to have a landscape
list of names, numbers and addresses that is 4 columns
accross. I can do this with File, Page Setup, Columns,
but then I have to shrink the page in design view, and to
do that, I need to get rid of all Headers and Footers,
which I want to keep.

Any suggestions?

Thanks!

Joe
 
If your recordset has separate fields for name, numbers
and addresses, create a new report using the report
wizard and use a columnar layout. When the report is
created view it in design view and go to Page setup and
choose the number of columns and column spacing and
column layout under the column tab. Also choose the page
margins and orientation under the Page tab. Go back to
your report and make sure that the sum of(maximum width
of the fields as displayed)x 4 plus the (column spacing)x
3 + left margin + right margin does not exceed the length
of the paper being used. If it does not then you are
finished. If it does, adjust the report (shorten labels
or set the can grow property of the textboxes to true and
decrease the width of the textboxes until you longer
exceed the limits of the paper size.
 
Back
Top