J
John
In Access 97 I have 2 graphs that display defect data for an item that
varies in length
from 1 meter to 1300 meters. Those graphs are in the report footer.
(MSGraph.Chart.8 embedded)
The report header has a bound field called [LengthM] that displays the total
length of the product.
Graph1 displays all defects from 1m - 650m, and Graph2 displays defects from
650m - 1300m. (MSGraph.Chart.8)
When graphing product longer than 650m Chart2 incorrectly shows defects on
preview, but correctly shows none on printout.
It appears to be a print preview problem, probably the same type of funny
behavior as
when a graph is in design view and it always shows some old data from ages
ago.
The problem is that this is confusing to the user. Although printout is
fine, the preview throws them off.
So, I tried to hide Chart2 when the [LengthM] <651, via the Main Form Format
event.
This causes the report to crash consistently, sometimes when previewing and
sometimes
when exiting the report. Although the Chart2 properties shows a Visible
property, I
noticed that the Intellisense in the module does not associate a Visible
property to Chart2.
Me.Chart2.(no Visible as a choice here)
I also tried making the graph 0 high and 0 wide to hide it, but get the same
crashing.
Tried using the Open, Activate, Page events to hide, but still crashes.
Am I addressing the Chart2 properly?
Does anyone know how I can hide that Graph2??
Thank you
varies in length
from 1 meter to 1300 meters. Those graphs are in the report footer.
(MSGraph.Chart.8 embedded)
The report header has a bound field called [LengthM] that displays the total
length of the product.
Graph1 displays all defects from 1m - 650m, and Graph2 displays defects from
650m - 1300m. (MSGraph.Chart.8)
When graphing product longer than 650m Chart2 incorrectly shows defects on
preview, but correctly shows none on printout.
It appears to be a print preview problem, probably the same type of funny
behavior as
when a graph is in design view and it always shows some old data from ages
ago.
The problem is that this is confusing to the user. Although printout is
fine, the preview throws them off.
So, I tried to hide Chart2 when the [LengthM] <651, via the Main Form Format
event.
This causes the report to crash consistently, sometimes when previewing and
sometimes
when exiting the report. Although the Chart2 properties shows a Visible
property, I
noticed that the Intellisense in the module does not associate a Visible
property to Chart2.
Me.Chart2.(no Visible as a choice here)
I also tried making the graph 0 high and 0 wide to hide it, but get the same
crashing.
Tried using the Open, Activate, Page events to hide, but still crashes.
Am I addressing the Chart2 properly?
Does anyone know how I can hide that Graph2??
Thank you