Updating MSGraph via VBA/VB within Access

[VickyLeigh]

Can anyone tell me the VB Code to update the Maximum and Minimum values for the Y Axis Scale in a graph on an Access form - I need to be able attach this to the OnChange property of a button on a form if possible.
For the sake of argument I have a form called forma and a graph object on this graph called graph1

Thanks for any help




[sig][/sig]

 

[pdupreez]

Hi

You could use the following code. Please ensure you have the Microsoft Graph object library referenced.

Me!NameOfYourGraph.Axes(2).MinimumScale = XYZ