468,135 Members | 1,455 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,135 developers. It's quick & easy.

Delete Page 2 of Report, Which Is Blank

Access seems to always generate a second page, which is blank, to my one page
report. How do I delete the second page? Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
Nov 13 '05 #1
4 9948
Go to File>Page Setup and change the left and right margins. Or in design
view, change the size of the report by clicking the right hand side of the
white space and drag it to the left

Jeff
"Nhmiller" <nh******@aol.comnojunk> wrote in message
news:20***************************@mb-m25.aol.com...
Access seems to always generate a second page, which is blank, to my one page report. How do I delete the second page? Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

Nov 13 '05 #2
>Go to File>Page Setup and change the left and right margins. Or in design
view, change the size of the report by clicking the right hand side of the
white space and drag it to the left


Now I see what happened -- I thought it was a page below. But the extra page is
a page to the right because my margins are set in such a way that not all the
data and white space can fit in 8.5 inches. I'll move the data columns in
tighter and drag in from the right. Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
Nov 13 '05 #3
nh******@aol.comnojunk (Nhmiller) wrote in message news:<20***************************@mb-m25.aol.com>...
Access seems to always generate a second page, which is blank, to my one page
report. How do I delete the second page? Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com


This is from Access help

My report prints blank pages.

If you get a blank page only at the end of a report or printed form,
make sure the Height property is set to zero for the report footer or
form footer.

If every other page is blank, make sure that the total width of the
form or report plus the widths of the left and right margins don't
exceed the paper size specified in the Page Setup dialog box (File
menu). You can use the following formula as a guide:

form or report width + left margin + right margin <= paper size

You can adjust the form or report in one or both of the following
ways:

Reduce the width of the form or report.

Reduce the margins or change the page orientation.

HTH

Sunil Korah
Nov 13 '05 #4
Dennis Lee Bieber wrote:
Practically every time I've created a report, I've had to find
all the lines, and shrink them by about 1/8"...

To do that, you could click in the right edge of the upper ruler above
your report. Click, or drag.

This action will select all controls that are within that range
(depending on a setting in Tools->Options, under forms/reports: the
default is 'partly selected' which will mostly be what you want)
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Jody Gelowitz | last post: by
1 post views Thread by Andy V | last post: by
2 posts views Thread by ME | last post: by
reply views Thread by Gunjal | last post: by
27 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.