Chart doesn't show data

[pbaxter]

I have a simple chart on a page of a tab control. The chart's data comes from a query.
when the form opens the chart can't be seen. If I
1) Move to another tab page and back again, or
2) Click on the chart object and then click somewhere else
then the chart magically appears.

How can I get the chart to show when the form opens?

[Rainlover]

This is a Windows Vista and a Windows 7 problem.

At a guess I would say that it would work fine in Windows XP.

Try adding some code to move the Focus from the main Form to the Chart and back again.

You should not have to do this but I have experienced a similar problem with Windows 7.

Please let me know the outcome.

[SoftwareMatters]

If what Rainlover has said doesn't work. Try doing a requery on the chart once the page has loaded.

[Rainlover]

Software matters

Yes you need to that as well, But on my 7 Machine I still need to swap the focus around.

I am almost prepared to call this a bug. But not yet.

[pbaxter]

Thanks, all.
Shifting focus by code (using the Activate event) didn't work directly. But putting a timer on the form and delaying the code-driven focus shift by 300 msec did work. Yecchh.
I'm going to try driving the focus shift by the OnUpdated event of the OLE chart and see if that works any better.

[pbaxter]

Using the OnUpdate event of the chart to shift focus solved the problem:

Private Sub ChartOLE_Updated(Code As Integer)
cboFind.SetFocus
End Sub

There's a short delay after the form becomes visible where the invisible chart has focus handles. Then focus shifts to cboFind and the chart appears.