Display message for blank subreport

I have a report with 13 subreports. Each one contains specific information
about a type of problem or application that could relate to the main record
(a location).

I have put the title for each subreport on to the Report itself and then of
course, if there is no information for that specific subreport, there is a
blank space before the next one.

What I would actually like is for a message to display that says something
like "No issue currently exists for xxxx (being the type of issue), or no
data has been recorded".

I am sure there is an easy way to do this but I haven't had any luck
searching. Any advice is appreciated!

Test the HasData property of the report in the subreport control.

Place a text box on the main report in the same section as the subreport.
Set its Control Source to an expression such as this:
=IIf([Sub1].[Report].[HasData], Null, "No issue exists for Sub1.")

Substitute the name of your subreport control for Sub1.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"carriey" <carriey RemoveThis @discussions.microsoft.com> wrote in message
news:B1D135B2-E47A-4736-8D96-DE61D636636F@microsoft.com...
>I have a report with 13 subreports. Each one contains specific information
> about a type of problem or application that could relate to the main
> record
> (a location).
>
> I have put the title for each subreport on to the Report itself and then
> of
> course, if there is no information for that specific subreport, there is a
> blank space before the next one.
>
> What I would actually like is for a message to display that says something
> like "No issue currently exists for xxxx (being the type of issue), or no
> data has been recorded".
>
> I am sure there is an easy way to do this but I haven't had any luck
> searching. Any advice is appreciated!