Report differs in design view & print preview?!?!

[Carley]

Hi There,
I'm not a tech bod, bu here's the problem....

I've made a couple of basic report charts using Access
2000. They preview fine, however when I go into design
view the pie chart & all its data is completely differend.
I have tried this with a number of different charts &
data, however I always get the same reslt: it looks fine
in print preview, but is completely different in design
view.

The data in design view is allways data
on "East" "West" "North"!!!

Even when it's been saved it still views ok in print, but
not in design....grrrr!!!

I need to view in design mode so I can save the chart as a
picture & use it in a project.

.....all help greatly appreciated!
cheers

 

[SA]

Carley:

There are two ways to resolve this, either:

1.) Add some default data to the Chart's data sheet that replicates your
expected result in some manner, or

2.) Add a little vb code to the On Print section of the report that contains
the chart something like this:

On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!TheNameOfYourGraph.Object
objGraph.Refresh
'This will update the data sheet
objGraph.Application.Update
DoEvents
Set objGraph = Nothing