BUG: Version 2409 creates error for MSGraph object in MS Access report

Question

Version 2406 does not have this problem. In Version 2409 (Build 18025.20160 Click-to Run), I get an error message while trying to set the MinimumScale and MaximumScale properties of the axis of the MSGraph.Chart.8 chart on a Microsoft Access report.

The logic to set the axis is in the report Detail_Format and looks like this:

    Me![OLEgraph].axes(2).MinimumScale = Forms!frmGraphScale!cboBottomRange

frmGraphScale is a form that allows the user to enter and apply min and max values for the X and Y axis. It is opened when the report is opened.

When report pages first render in print preview, the Detail_Format logic works ok. A button on frmGraphScale toggles the Visible property of the chart object, which causes the report to rerun the Detail_Format logic, which is then supposed to then reset the scale using the logic above to apply scale values from frmGraphScale.

Until recently, that worked fine. But after updating to Version 2409, I get this error:

-2147220995 Automation error

Object is not connected to server

When I click OK on the error message, the database crashes.

If I step through the VBA logic, it is erroring out on the line that is trying to set the MinimumScale property. It is acting like it has lost connection to the MSGraph chart object. Again, this only occurs when Detail_Format runs a second time due to showing and hiding the chart object.

Is this a known issue and is there a resolution? I have scores of reports using a MSGraph chart that are used by hundreds of users that rely on this functionality to reset the scale of their charts after the report is in print preview.

Answer 1

How many different reports and how many different chart objects does this impact?