Need output on blank report. "Page intentionaly blank"...

[ifshmn]

I am finishing up building a report and have one last item to add. I am using multiple subreports and need each one that is blank to say "No activity for specified period" for each of those reports. I've tried going through the queries, or adding a text box to the report with the following text, but I either get an error (in report) or get nothing (in query).

IIf(IsNull([Details]),"No activity for this audit period.",[Details])

For compliance reasons, I need to know if there is no data and not a broken link of some sort.

Thanks!

 

[ifshmn]

I found the "on no data" report property, and can either print a seperate report that says "no data" or have a msg box appear, but I would much prefer it print directly in that section.

 

[Remou]

Have you considered the HasData property? For example:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.[abc subreport].Report.HasData Then
    Me.txtMessage.Visible = False
Else
    Me.txtMessage.Visible = True
End If

End Sub