Newbie Question regarding OnNoData property

[Jacque]

Hi All,
I'm a total newbie to MS Access so please bear with me.

I'm currently supporting a set of Access reports which are displaying summaries, details and charts. There is one main form and it contains many reports within it. I don't know if this is the norm but it's what I'm dealing with at the moment.

My issue is regarding the Charts, if there is no data returned the report displays a useless box on the report which my users don't like. It appears that some of the charts have their own report and some have multiple charts in a report. Can I use the OnNoData property to supress Charts that return no data and can I supress single charts in a report where multiple charts reside? If so, how do I do it? I do want the remainder of report to display, my users just don't want to have the empty box being displayed if there isn't any data.

I appreciate any and all help.
Thanks!
Jacque

 

[scottian]

why not play with the visible property. on the OnOpen event do a dcount on the reports data, if no data then MyObject.visible = no


"My God! It's full of stars...

 

[Jacque]

Thanks for the response, I found the On Open property and will give it a try. I'm going to try the code builder and see what happens.

Thanks Again!!