[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


MS Access – Repeating Sub-Report Headings on Each Page

Posted on
13,927 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

Why Diversity in Tech Matters
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

  • 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 60

Author Comment

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


Expert Comment

by:jared Winton
LVL 60

Author Comment

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


Featured Post

Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

Join & Write a Comment

If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
When converting amounts between different currencies, you need exchange rates. This article demonstrates how to obtain these from no less than nine different sources, either for free or - for intense or demanding use - for a fee.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month