Change access forms title in vba

[Kwee]

I use the chart wizard in Access 2000. I want to change title at runtime through VBA. Can anyone help me changing the title through VBA....???
Any suggestion will be appreciated......!

[Reegan]

Try this code if possible

Sub Macro8()
ActiveSheet.ChartObjects(8).Chart. _
ChartTitle.Characters.Text = "Text"
End Sub

[opaper]

They know the entrance title, by them the characteristic. The following code becomes the entrance title along the category entrance :

ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Caption = “WEEK”

[MindSpace]

Try this:

Sub Macro1()
With Sheets("3. FHS").ChartObjects("ProjGraph1")
.Chart.HasTitle = True
.Chart.ChartTitle.Text = "This is New Title"
End With
End Sub