[AccessD] Chart on Form Refresh

I use the following code to format the x axis of a chart on a form. The first time I open the form it does not work. The second time it reformats the x axis. Do I need some other statement to refresh the chart or am I calling it from the wrong event.

Private Sub Form_Open(Cancel As Integer)
    Dim GraphApp As Graph.Application
    Dim GraphObj As Graph.Chart
    Dim XMin As Single

    Set GraphObj = Me!chtPlantChart.Object

    GraphObj.Axes(1).MinimumScaleIsAuto = True
    XMin = GraphObj.Axes(1).MinimumScale
    GraphObj.Axes(1).MinimumScale = XMin + 1

End Sub


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.