ACC2002: Chart Intermittently Displays Sample Data (304898)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q304898
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

Charts in Microsoft Access 2002 reports may intermittently display sample data rather than real data when you print or print preview the report.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft Office XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

307841 OFFXP: How to Obtain the Latest Office XP Service Pack

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was first corrected in Microsoft Office XP Service Pack 1.

MORE INFORMATION

Steps to Reproduce the Problem

  1. In a new database create an Access table, as follows:
       Table: tblSampleData
   ----------------------------
   Field Name: ID
   Data Type: Text
   Indexed: Yes (No Duplicates)

   Field Name: Name
   Data Type: Text

   Field Name: Price
   Date Type: Number
   Field Size: Long Integer
  2. Switch to Datasheet view, and then type the following records:
       ID     Name     Price
   ---------------------
    A     John     10
    B     Mary     20
    C     Tony     30
  3. In the Database window, click Reports under Objects, and then click New.
  4. In the New Report dialog box, click Chart Wizard, and then select tblSampleData from the list of tables and queries. Click OK.
  5. Move ID, Name, and Price from the Available Fields list to the list of fields for the chart. Click Finish.
  6. Close and then save the form as rptChartReport.
  7. Close and open the report several times. Note that intermittently you see sample data instead of the actual data.
Modification Type:MajorLast Reviewed:4/7/2006
Keywords:kbQFE KBHotfixServer kbbug kbfix kbOfficeXPpreSP1fix kbOfficeXPsp1Fix KB304898
©2004 Microsoft Corporation. All rights reserved.