Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Access 97 report charts duplicate in print preview

Posted on 2004-08-18
Medium Priority
Last Modified: 2008-07-03

I have an Access 97 database that does some reporting.  This particular report involves charts.

The design of the report has 1 detail section, and within the detail section is a group footer which groups the data.  The data is grouped and displayed on a chart.  When this report printed to the printer, it has four pages of charts.  On pages 2 and 3, two different charts print on each page - one on the top half of the page and a different one on the bottom half of the page. The problem is that when the same pages are viewed in print preview, the same chart at the top of page 2 is duplicated on the bottom half of page 2.  On page 3 in print preview, the same thing occurs...the first chart on page 3 is repeated (duplicated) on the bottom half of page 3. However, when the report prints to the printer, the correct, different charts print.  

I believe the problem lies with the group footer and may have something to do with the OnFormat event. But after spending nearly three days trying everything under the sun to make the correct charts print in both print preview and on the printer, the only resolution I have been able to come up with is to do NewRowOrCol Before Section which forces each chart to print on a separate page.  When each chart prints on its own page, the print preview and hard copy printing are fine.  I would like to see if I can come up with something that would allow two charts to print to a page.  

Any ideas would be appreciated as I am stuck as to what may be causing this.  Thanks.
Question by:azjz
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

by:Eric Flamm
ID: 11834211
First off, Footers don't appear in the Detail section; they are sections unto themselves.

Can you post the code from the Report class module (all events for all sections, unless its really long)? That way, we can see if anything is happening that would cause this result. I can't say I ever did much with charts in Access 97, but they seem to work OK in Access 2000.


Author Comment

ID: 11835838
Thanks for the reply.  There is no code in the report module or in any of the controls.

Accepted Solution

Eric Flamm earned 1600 total points
ID: 11836059
I suspect your graph objects are out of sync with your data when displayed in print preview, but get synced when you print them. There's an article on the MIcrosoft KB about this.;en-us;318096&Product=acc2002

A Chart on a report displays the incorrect data in Access 2002


Author Comment

ID: 11842291
Thanks again for the posting, eflamm.  I used method 2 in the MS knowledge base article, and it worked great.  Thanks for your help.  It was more than worth the points.

Have a great day!

Expert Comment

by:Eric Flamm
ID: 11844997
You're welcome - good luck!


Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question