Help with report.

[wizof103]

I finally have a report to print only one record. Now the problem, I
don't know what I did, but the first page on teh report prints exactly
the way I needed it to but, but, but, I have a second page that prints,
and it prints just the page header and the page footer. They are the
only things on the second page. Anyway to get rid of them .. Thanks in
advance.

 

[Guest]

Check that the report width does not exceed the width allowed for your report
layout (portrait or landscape) when you add in the margins specified. To
determine the margins specified, click on File > Page Setup... with the
report selected (you can also access this information in report design view
with File > Page Setup...).

For example, if your printer is set up to use 8.5" x 11" paper, your report
is specified as Portrait, and you have 1" left and right margins, then your
report cannot exceed 6.5 inches in width.

Also check that the sum of the heights for the various sections, plus the
top and bottom margin values, does not exceed the allowable height for the
layout mode & paper that you have selected. Access 2003 will warn you of this
problem. Access 2000 will not. I don't remember at the moment if Access 2002
includes this warning. One sympton of exceeding allowable dimensions is that
a page counter displayed on the report will not reflect the extra blank page.

Also, check out some of the grouping options under View > Sorting and
Grouping in report design view.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I finally have a report to print only one record. Now the problem, I
don't know what I did, but the first page on teh report prints exactly
the way I needed it to but, but, but, I have a second page that prints,
and it prints just the page header and the page footer. They are the
only things on the second page. Anyway to get rid of them .. Thanks in
advance.

 

[wizof103]

I tried to move everything up. I still get the page footer and page
header on a second page.

 

[Guest]

What about the total width of your report (ie. report width + left and right
margin specified)? What version of Access are you using? For example, in
Access 2003, you should see a warning symbol.

Also, if you have a page counter on your report, is the indicated number of
pages correct or not?


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I tried to move everything up. I still get the page footer and page
header on a second page.

 

[Ron2005]

What is the last detail thing that you are printing on the page (that
is not header or footer.) If it is perhaps a potentially large text box
or memo field that may have some blanks in it, perhaps the report
mechanism believes it needs a second page to print this information
which is blank.