<

Watch MS Access – Repeating Sub-Report Headings on Each Page

Posted on
15,213 Points
5,913 Views
8 Endorsements
Last Modified:
Published
Experience Level: Beginner
4:09
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

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

Author Comment

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

Jim.
0

Expert Comment

by:jared Winton
Thanks!
0
LVL 66

Author Comment

by:Jim Dettman (EE MVE)
Quite welcome.

Jim.
0
Do you need a date time picker, how about just a time picker?  Would you like to use something other than the basic Access date picker which is available when you have a textbox which contains data formatted as a date? Give this date time picker a t…
This is a rather simple but effective way of searching while typing on a Microsoft Access Combobox.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month