MsChart problem...[RESOLVED]

[Pirre001]

In Access (VBA) this code doesen't work. But in VB it works?

Private Sub Command1_Click()
Dim oleGrf As Object
 
Set oleGrf = Me.OLEchart.Object
 
oleGrf.ChartTitle.Text = "Test"
 
Set oleGrf = Nothing
 
End Sub

Why?

[Hack]

In Access (VBA) this code doesen't work. But in VB it works?

Private Sub Command1_Click()
Dim oleGrf As Object
 
Set oleGrf = Me.OLEchart.Object
 
oleGrf.ChartTitle.Text = "Test"
 
Set oleGrf = Nothing
 
End Sub

Why?

I don't know but I suspect the VBA people will.

Moved to Office Development.

[DKenny]

Pirre
Your syntax look right.

Here is a one liner that should change your Chart Title

Me.OLEchart.Object.ChartTitle.Text = "Your text here"

The attache Db shows this in action.

[Pirre001]

Big Thanks Kenny!