Prev: Grouped/Sorted Report by Month
Next: Hide Sub Report(s) when records are null
From: John Spencer on 24 May 2010 11:40
In the section of the report that has the subreport, you would need some VBA
code like the following in that sections format event

IF NameOfSubReportControl.HasData Then
NameOfSubReportControl.Visible = True
ELSE
NameOfSubReportControl.Visible = False
END IF

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Bruce wrote:
> John,
>
> I cannot locate where I would use the HasData property of the sub-report. I
> am aware of the can shrink property and have that set to yes (also have the
> can grow property set to yes). I have looked at each line in the properties
> window but cannot locate where I set the HasData property. In fact I typed in
> HasData into the help menu and there were no results found. Could you please
> give me a little more assistance?
First  |  Prev  | 
Pages: 1 2
Prev: Grouped/Sorted Report by Month
Next: Hide Sub Report(s) when records are null