Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


MS Access – Repeating Sub-Report Headings on Each Page

Posted on
12,574 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

How Blockchain Is Impacting Every Industry
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

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

Author Comment

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


Expert Comment

by:jared Winton
LVL 58

Author Comment

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


Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Join & Write a Comment

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month