<div>
Try to use report event - On No Data and there set your control to visible
</div>


Try to use report event - On No Data and there set your control to visible

<div>
The report will always have data but some of the detail sections will not. For instance there will be data for 40 clients but no data for one. Can I put this on the report level or do I need something on the detail level. This report breaks on Ckient.<br />
Thanks
</div>


The report will always have data but some of the detail sections will not. For instance there will be data for 40 clients but no data for one. Can I put this on the report level or do I need something on the detail level. This report breaks on Ckient.
Thanks

<div>
Is client presented in source query if there are no data records? May be for your case is better to use subreports, where you can analyze - are there data or not
</div>


Is client presented in source query if there are no data records? May be for your case is better to use subreports, where you can analyze - are there data or not

<div>
Thanks - I will modify the report. I appreciate your help!
</div>


Thanks - I will modify the report. I appreciate your help!

<div>
Thanks - That is exactly what I ended up with as my solution.
</div>


Thanks - That is exactly what I ended up with as my solution.

<div>
<div class="content wysiwyg-content">
I have a report that breaks on client. If there is no detail information for a client I want to display a text box that says &quot;No information&quot;. I have the text box hidden and will change it to visible based on the trigger. <br />
Problem - I have tried .HASDATA but it always returns true even if the detail section is empty.<br />
I have dozens of clients and they are populated 95% of thie time. This will put the finishing touches on the report.
</div>
</div>


I have a report that breaks on client. If there is no detail information for a client I want to display a text box that says "No information". I have the text box hidden and will change it to visible based on the trigger. 
Problem - I have tried .HASDATA but it always returns true even if the detail section is empty.
I have dozens of clients and they are populated 95% of thie time. This will put the finishing touches on the report.

How do I reference the detail section of an access report to check if itis empty

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.