Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Width of Report (2002)

    I have a stack of questions, but will discipline myself to ask one at a time. <img src=/S/angel.gif border=0 alt=angel width=15 height=21>
    My project is to have a report, with subreport, that the user can filter from a pop up form to select by any of 6 criteria, or run the entire report.
    Question one is related to the report itself. I'm getting 3 blank pages between each page with information. The problem seems to be related to width, but I can't find a control to correct this. I'm hoping that correcting this will eliminate some other issues so I wont have to bug you so much.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Width of Report (2002)

    If the page setup of the report specifies Letter size paper, portrait orientation, the paper width is 8.5". Say the left and right margins are 1" each, then there is 6.5" left for the actual width of the report. (You can make similar calculations for other margin settings and for landscape orientation.)
    If the width of the report is more than the amount calculated as above, one report "page" will take up at least two physical pages. You can check the width in the Properties window, and see it easily if you display the rulers. If the report is too wide for the paper width minus the margins, you must either change the margins or the report width. You can try dragging the right edge of the report to the left (in design view). If that has no effect, you will have to move some controls to the left.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Width of Report (2002)

    Thank you Hans. Now on to the next "too simple for words" question.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •