Why is my report printing 16 pages of the same data?

[ripvws]

I have arranged about 40 calculated text boxes within the dimensions of a 1
page report. It all fits within the boundaries of a single page but I get 13
pages of the same information printed out. It started out as 16 pages but I
did something that reduced it to 13 pages. I do not know what I did. I
checked that "no. of copies" is set to 1 in the print dialog box. My page
setup is landscape with 0.5 inch margins. I am printing to an HP laser
printer.

 

[aeronaut]

I have exactly the same problem as what you described. The number of pages
printed in the report corresponds to the number of records in the the query
to which the my report is bound. My report contains text boxes that use the
DCount function therefore I can solve the problem by changing the undelying
query to one that contains only 1 record. The DCont function still works the
same way and I do not get the same information repeated on multiple pages.
Obviously, this can be only when you use the DLookup, DCount, or DSum
functions.

 

[Marshall Barton]

I have arranged about 40 calculated text boxes within the dimensions of a 1
page report. It all fits within the boundaries of a single page but I get 13
pages of the same information printed out. It started out as 16 pages but I
did something that reduced it to 13 pages. I do not know what I did. I
checked that "no. of copies" is set to 1 in the print dialog box. My page
setup is landscape with 0.5 inch margins.

If your report is not using data from a record source
table/query, the it is an unbound report and should not have
anything specified in its Record Source property.