NoData

  • Thread starter Thread starter dale
  • Start date Start date
D

dale

Is there a way on a subform to display a message like "No Entries" in
one of the fields or a label that is normally on the subform if no data
is present for the subform.
 
I found this on the web and it worked

Using the NoData event to cancel a subreport has no
signiicant effect because a subreport with no data will not
do anything.

A mainreport text box can check if a subreport has no data
and display whatever you want by using an expression like:

=IIf(subreport.Report.HasData,
subreport.Report.subreporttextbox, "No data for this
report")

Thanks to Marsh MVP MS Access
 
I believe the post refers to a subform and not a subreport. There seems to
be no way to trap a no data situation on a subform.

I am having the same problem.
 
Back
Top