A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Phone list report with multiple columns



 
 
Thread Tools Display Modes
  #1  
Old May 23rd, 2004, 07:29 PM
Joe
external usenet poster
 
Posts: n/a
Default Phone list report with multiple columns

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

  #2  
Old May 23rd, 2004, 09:15 PM
external usenet poster
 
Posts: n/a
Default Phone list report with multiple columns

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.
-----Original Message-----
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

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.