On 4 Nov 2005 11:12:05 -0800, TD wrote:
I would like to set the value of the Y axes on my graph at runtime. I
created the graph my opening a form and placing an unbound object frame
on it then placed the MS Graph control into this. Next I copied /
pasted this object into a report. How can I do this? I can't fiqure
out how reference the MS Graph control in code.
Thanks,
TD
Graphs are in OLEUnbound controls.
Here is an example setting the Chart's Title using code.
Place the code in the Report Header Format event (or wherever it works
for you).
Me!OLEUnbound7.ChartTitle.Text = Forms!frmDate!Location & " Avg.
Arrival Rate for the Year " & Forms!frmDate!StartDate
Me!OLEUnbound7.Axes(2).HasTitle = False
Me!OLEUnbound7.Requery
Change OLEUnbound7 to whatever the actual name of your control is.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail