Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report not printing all records

Status
Not open for further replies.

flybravo

Programmer
Jun 30, 2003
35
US
I have a single table named tblUser. I created a report named rptUser. I want the report to print a single page for each user. I have added the UserID to the Page Header and the information on the detail section. When I preview the report I only see 10 of the 30 pages. I have the record source for the reporty to be linked to the tblUser. There are no filters on the report. I can get all of the user to print correctly if I increase the size of the detail, page header and page footer. As soon as I add more records, not all of the users are printed. What could I be doing wrong or is access programmed like that.


Thanks
 
I would only place the User fields in the Page Header if each detail section printed on its own page. You can do this with the Force New Page property or a Page Break control.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top