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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|