I am new to Access and having problems with my report. I have a report that is attached to a form and is populated with data from a table that is bound to the form also. When I access the first record on the form and click on a the view report button I created, it displays the record. However, when I go to the second record and click view report, it still shows the first record. In order for me to see my second record on the report, I have to go to the fifth page on the report. Where did I go wrong, and how can I fix this? All inputs will be appreciated.
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 issues!
- Thread starter roman33
- Start date
With this limited information I would first check the report when you see your first record. Check to see if there are more pages to the report. Could be that you are selecting more records and they are being printed on seperate pages.
How did you create the Print Report button? With the wizard?
Please explain just how you processed through the wizard and created the report. Which records you told the wizard to select on.
Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]
How did you create the Print Report button? With the wizard?
Please explain just how you processed through the wizard and created the report. Which records you told the wizard to select on.
Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]
- Thread starter
- #3
scriverb,
Thank you for your reply. I created the report in design view from scratch adding each control individually. The issue is not the print function but the way my report is displayed. It displays one record but when you click on the next navigation button, it displays a blank page, then the next record. I want it to display the next record when I click on next in the report view.
Thank you for your reply. I created the report in design view from scratch adding each control individually. The issue is not the print function but the way my report is displayed. It displays one record but when you click on the next navigation button, it displays a blank page, then the next record. I want it to display the next record when I click on next in the report view.
Easy fix. The page of the report is only so wide. You have created a report that is wider than the available page space. So the second page even though it seems blank is really some control or line or box or something that makes the report too wide so it must be displayed on another page.
Check the PageSetup for the margins and whether it is portrait or landscape. Example: Portrait pages have 8.5 inches of space. If the margins are set to 1" on each side then you can only have controls and lines and such that take up 6.5". If a control extends this area to 7" then there will be a second page.
Let me know what you find.
Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]
Check the PageSetup for the margins and whether it is portrait or landscape. Example: Portrait pages have 8.5 inches of space. If the margins are set to 1" on each side then you can only have controls and lines and such that take up 6.5". If a control extends this area to 7" then there will be a second page.
Let me know what you find.
Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]
- Status
Similar threads
- Locked
- Question
