<

MS Access – Repeating Sub-Report Headings on Each Page

Posted on
17,571 Points
7,271 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 69

Author Comment

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

Jim.
0

Comment

by:jared Winton
Thanks!
0
LVL 69

Author Comment

by:Jim Dettman (EE MVE)
Quite welcome.

Jim.
0
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to reconfigure a …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month