Programatically Modifying a Chart

[theburnetts]

HELP!! I have been fiddling with a chart on an Access form all day and
can't figure this out. It is very frustrating. I used the Chart
Wizard to add a chart to an Access form. Now I want to write some code
that will manipulate various parts of the chart (Axis min/max, chart
title, etc.) However I can't find something that will really explain
it to me. When I am in the code and I type the name of the chart the
Intellisense doesn't seem to give me all of the chart properties and
methods. It just seems to give me the basic object properties and
methods. I am wondering if I am not creating the reference to the
chart object correctly. Here is what I did:

- Create a chart using the Chart Wizard.
- Named it objChart

Now in code...

Private Sub Form_Load()
objChart.Axes(1).minimumscale = 0
objChart.Axes(1).maximumscale = 100
objChart.ChartTitle.Text = "My Chart"
End Sub

This always bombs on the line where I set the title. It's weird. It
understands the lines that change the scale (even though the properties
don't come up in Intellisense). It's like the form doesn't seem to
understand what class objChart is or there is some other secret way to
get at the properties and methods of the object in code.
I am using MS Office 2003.

Thanks,
Corey