Posted 4 August 2017, 2:48 pm EST
i was given this code a little while ago by someone from this site, to not print a sub report if it had no data. however for some reason when transfering the dev system to a new machine the code no longer works
Private Sub ActiveReport_NoData()
Dim sect As Section
For Each sect In Me.Sections'
sect.Application.Height = 0
sect.Application.Visible = False
can anybody give me any clues as to where to start looking to rectify this problem ?