MS Access – Repeating Sub-Report Headings on Each Page

Posted on
13,443 Points
8 Endorsements
Last Modified:
Experience Level: Beginner
Jim Dettman (Microsoft MVP/ EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.

Video Steps

1. The problem with sub-reports and headings

2. Add a dummy group to the sub report using the expression =1

3. Set the “Repeat Section” property of the dummy group’s header to yes

4. Move the column headings to the dummy group’s header

Ultimate Tool Kit for Technology Solution Provider
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2

Expert Comment

by:Ruth Barnhardt
Thank you Jim.
This was perfect! Just what I needed.
I know Access very well... but these little tricks are great to have. Thanks for sharing!
LVL 59

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Glad you could use it.


Expert Comment

by:jared Winton
LVL 59

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Quite welcome.


Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month