Sub Reports with no Data

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
 
D

Duane Hookom

You can use a text box on the main report with a control source like:
=IIf(subrptControlName.Report.HasData,Null,"Sorry -there....")
 
D

Dave

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...
 
Top