Control properties of a chart in MS ACCESS with VBA

[airbeone]

Hello,

I would like to know if there is a way to control different properties of a chart in MS ACCESS from VBA such as the scale of the axis, Title, Legend, variables...

Merci.


R1

 

[namliam]

Yes its very possible, you cannot however ad a second axes or something extreem like that...

But changing the scale, title, etc Yes ...

 

[airbeone]

exemples ???

The second question is how...

Do you have exemples of this vba programs ?

Merci.

R1

 

[namliam]

IIRC it is as easy as:

Me.YourGraphObjectName.Scale = 1000
Me.YourGraphObjectName.Title = "Some name"
etc...

 

[modest]

Close, that's what I would have thought but the chart objects are a little trickier to work with...


Reports("Report Name").ChartObjectName.ChartTitle.Text = ""

There are several different objects you can use instead of text, one might be Caption or Name

 

[ChrisO]

There is a demo in Sample Databases that shows how to manipulate some of the properties of charts in forms and reports.
It should run OK in >=A97 and with any regional settings.

Hope you find what you require in that demo.

Regards,
Chris.

 

[Oldsoftboss]

Another sample I have