No values in subreport - show default text

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.
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamically Loading Images in a subreport 2
Report asks for Parameter and Won't Display Subreport 7
Access How to prevent subReport from breaking across pages? 1
Display "No details" if subreport has no records 1
Reports and SubReports Spacing 6
Error from Subreport 2
Report and subreport 4
Report and subreport question 2

Top