By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,696 Members | 2,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,696 IT Pros & Developers. It's quick & easy.

How to reference the MS Graph control place inside an unbound object frame

P: n/a
TD
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
TD
When I type Me.OLEUnbound3. there are no options like Axes() or
ChartTitle.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.