Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Reports and page setup

Reports and page setup

Reports and page setup

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?

RE: Reports and page setup

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

RE: Reports and page setup

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


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close