Width of Report (2002)

Topic

New Reply

I have a stack of questions, but will discipline myself to ask one at a time.
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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote