Display "No Data" for Charts with No Data

[SierraJuliet]

To all the Access ninjas...

As the title suggests, does anyone know a 'simple' way to display "no data" on a chart when there is no data present, instead of the chart being blank?



Thanks!

[Micron]

I have long refrained from using Access charts. I suppose the report OnNoData event doesn't apply? If it does, you could simply hide the chart control using that event.
If not, maybe a hidden textbox on the report that uses DSum on your data. If 0, then hide the chart control. I'd suggest the OnCurrent event for the report.

[SierraJuliet]

Good idea. I will use a hidden field that on strSQL = 0 will make visible. Thanks Micron.

P.S. The chart is on a tab page (no sub form or report).

[Micron]

You're welcome. Hope it works.