Change access forms title in vba

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......!

Try this code if possible

Code:

---

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

---

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

Quote:

---

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

---

Try this:

Code:

---

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

---