Prev: Return Null Values
Next: How do I use a table to validate data being entered into another
From: PeterM on 23 Mar 2010 18:51
I'm using AC2003. I have a chart on a form. Sometimes the chart has no data
and the chart displayed is blank, which I expect.

My question is, is there a way to determine whether the chart has any
information on it? I'd like to display a label that says something like "No
Information Found".

Thanks in advance for your help.
From: Duane Hookom on 23 Mar 2010 20:01
A chart has a row source and maybe a link master/child properties. You
should be able to use Dcount() or something to determine if there are any
records.

--
Duane Hookom
MS Access MVP


"PeterM" <PeterM(a)discussions.microsoft.com> wrote in message
news:9A8B8191-EA2C-429A-ABA5-E6E8EE09DB7F(a)microsoft.com...
> I'm using AC2003. I have a chart on a form. Sometimes the chart has no
> data
> and the chart displayed is blank, which I expect.
>
> My question is, is there a way to determine whether the chart has any
> information on it? I'd like to display a label that says something like
> "No
> Information Found".
>
> Thanks in advance for your help.

 | 
Pages: 1
Prev: Return Null Values
Next: How do I use a table to validate data being entered into another