If no records exist

[mrwhitehat]

Fellow access users:

I have a report with a list of Items associated with a Person. Some of the "Person" records do not have any "Items" associated with them. If that is the case, how can I print an alternate text such as "No Items Detected"?

It tried the following, but it did not work...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Report.HasData Then
Me.lblNoMinistry.Visible = False
Else
Me.lblNoMinistry.Visible = True
End If
End Sub



Thank you.

[June7]

Report structured to show a person even if there are no related 'Items' records? Is this a report/subreport? If all persons are displayed, what piece of missing data indicates there are no Items - ItemID? Try expression in textbox: =Nz([ItemID],"No Items Detected")