No values in subreport - show default text

  • Thread starter Thread starter rwilliams616
  • Start date Start date
R

rwilliams616

I have a report with a subreport. The subreport contains photos related to
the main record. I would like to have the report to say something like
"None" or "No photos" when there are no photos associated with the record.
So for example, if I don't have any photos for the record, I would like to
print out "None" in that section. What would be the easiest way to do this?

Thanks for the help.
 
Add a text box to the main report, with its Control Source set to:
=IIf([Sub1].[Report].[HasData], Null, "No photos")
replacing Sub1 with the name of your subreport control.
 
Back
Top