report has blank pages

[minernine]

I have created a report which inserts blank pages between every page in the report. The page layout looks normal. Any ideas?

 

[EllieFant]

Look at the layout of your report in design view. You can see the area where you can create your report. Go over to the right edge and watch for your mouse to turn into a cross with arrows on the left/right bar. left click your mouse and hold down the button. Drag to the left and then let go. That will reduce your "report" printing area and should get rid of that blank page...if not...make sure you don't have any of your fields that go over the margin (usually about 6.5 inches on my screen). Hope I haven't confused you in my explaination.


Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

elliefant@qwest.net

 

[jiqjaq]

If this happens every other page then your page width in the design view of the report is larger than that allowed from the page setup for the report.

From the page setup dialog box take page width from the size on the Page tab, then subtract the left and right margins from the Margins tab. This is the maximum width that your report can be without causing overflow. Any overflow will be printed on the next page.

For portrait letter size paper, the width is 8.5 inches, for landscape it's 11. IF you use a different paper size then you can calculate accordingly.

So if your paper size width is 8.5 and both left & right margins are .5, you can only fit 7.5 inches onto the report without causing extra pages. Access will only give you warnings when the report width is > paper size width.

 

[Garridon]

Check any fields or lines that come to the edge of the report. If any of these are a shade too long, the report will add a blank page.

Linda Adams

http://www.hackman-adams.com

http://www.david-hedison.com