Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / April 2004

Tip: Looking for answers? Try searching our database.

Report Page Break

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michael H - 30 Apr 2004 17:53 GMT
I have built a Students/Classes database and I need a
report that will print out transcripts.

The report is set up fine, however, I need to have the
report print a different student on each page. Right now,
the report prints the student records on top of each
other.

Thanks in Advance
Dan - 30 Apr 2004 18:17 GMT
Good Afternoon!

Depending on how your report is set up, you can use
the "Force New Page" property to make this happen. This
property should be available in the Detail Section and any
Group Header/Footer sections you have set up. Setting this
property to "After Section" will usually work, but again
this can depend on how the Sections in the report are set
up. You can experiment with the settings to see how they
change the page breaks. hope this helps!

Dan

>-----Original Message-----
>I have built a Students/Classes database and I need a
[quoted text clipped - 7 lines]
>Thanks in Advance
>.
fredg - 30 Apr 2004 18:30 GMT
> I have built a Students/Classes database and I need a
> report that will print out transcripts.
[quoted text clipped - 5 lines]
>
> Thanks in Advance

In report design view, click on View + Sorting and Grouping.
Enter the StudentID field in the top panel.
Choose Header Yes in the bottom panel.
Save the change.

Click on the Group Header and set it's ForceNewPage property to Before
Section.
Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.