<

MS Access – Repeating Sub-Report Headings on Each Page

Posted on
15,739 Points
6,439 Views
8 Endorsements
Last Modified:
Published
Experience Level: Beginner
4:08
Jim Dettman (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

8
  • 2
4 Comments

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!
0
LVL 67

Author Comment

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

Jim.
0

Comment

by:jared Winton
Thanks!
0
LVL 67

Author Comment

by:Jim Dettman (EE MVE)
Quite welcome.

Jim.
0
When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass.   In this example a form flashes a message while the stored procedure executes, and then closes itself on…
The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month