I have an Access report that has a bar chart object on it. I would like to programatically change the horizontal axis based on some date values from a table. Also the horizontal axis is numeric rather than time value - can this be changed to time value programatically so it can display full months?
Here is the code that doesn't work:
Private Sub Report_Open(Cancel As Integer)
Dim graphObj As Object
Set graphObj = Me!Graph0
graphObj.Axes(2).MinimumScale = 10000
The error message is:
Runtime error '438'
Object doesn't support this property or method
If I put this code in the graph object On_click event the axis scale changes but I don't want to have to click the graph to make it work properly especially since the report has 4 overlapping graphs.