Step through the sections in a report
Posted on 2011-02-22
I want to address each section in a report with VBA, which is already open in design mode.
I specifically want to use the For Each code.
What I've got now is
Dim scn As Section
For Each scn In [Reports]![rptProfiles1] ' "rptProfiles1" is the report name
Debug.Print Reports!rptProfiles1.Section(scn).[Name], Reports!rptProfiles1.Section(scn).[Height]
I just cannot get this section one to work.
However, what is working for the same report is
Dim ctl As Control
For Each ctl In Reports!rptProfiles1
Debug.Print ctl.Name, ctl.Height
Please help with the section code