Sub Reports with no Data

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Access 2003

Would like to be able to populate a report with text ("Sorry - there were no
incidents this month") if the sub report is empty (contains no data)

How can this be done easily?

Any help here will be appreciated.

Thanks in advance


dave
 
You can use a text box on the main report with a control source like:
=IIf(subrptControlName.Report.HasData,Null,"Sorry -there....")
 
Thanks you - I will try that

dave

Duane Hookom said:
You can use a text box on the main report with a control source like:
=IIf(subrptControlName.Report.HasData,Null,"Sorry -there....")
Click to expand...
 
Back
Top