Control MSgraph

E

Ed

I want to control a msgraph from access. I have the chart in a form. I have
the help file. I do not know how to set mychart in:
With myChart
.HasTitle = True
.ChartTitle.Text = "February Sales"
End With
 
K

Kevin K. Sullivan

Your form contains a Control, probably called Graph1. You will use the
Object property of that control, not the control directly:

Dim myChart as Graph.Chart

Set myChart = Me!Graph1.Object 'code in Form's module

'or

Set myChart = Forms!MyForm!Graph1.Object 'code in standard module

With myChart

.................

HTH,

Kevin
 
E

Ed

Thanks, that got me there!
ed

Kevin K. Sullivan said:
Your form contains a Control, probably called Graph1. You will use the
Object property of that control, not the control directly:

Dim myChart as Graph.Chart

Set myChart = Me!Graph1.Object 'code in Form's module

'or

Set myChart = Forms!MyForm!Graph1.Object 'code in standard module

With myChart

................

HTH,

Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top