Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reports and page setup

Status
Not open for further replies.

Roushmach1

IS-IT--Management
Jun 15, 2007
2
0
0
US
I already have a report created but when I was re-sizing the columns and adjusting the layout, my one page report now appears as 3 pages wide by 1 page high. I have already saved the file again but how do I resize the report to 1 page width? All my columns are in the first page but the line breaks between data extend the 3 pages wide?

 
Here are some ways to make the report more compact.

1) In design on the report, use the View menu to turn off "Show Data" so you can see the field boundaries clearly.

2) Check the File menu, Page setup to make sure your margins and paper size, orientation, etc are correct.

3) Check the footer to see if the "page number" is in the first page area or outside of it. If it is outside, move it back in the first page boundary.

4) Now you can move the fields into the first page area one at a time. In this mode, you will need to move the column headers one at a time also. You can resize fields if needed.

5) Check the header to make sure all text blocks are entirely within the first page boundary. Note that Edit, Select All will show you all fields and their boundaries so you can check for anything extending to the right side into a second page.

Sue Sloan
 
#5 took care of it. Thank you very much for your help Sue.


Brian.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top