ACC: Microsoft Graph Always Shows Sample Data in Design View

• Microsoft Access versions 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

After you insert a Microsoft Graph object into a Microsoft Access form or report, the graph object always displays sample data in Design view. This occurs even if you have opened the form or report, and the graph object correctly displays the actual data in Form view or Print Preview.

RESOLUTION

The resolution to this problem depends upon whether you are using the graph in a form or a report.

Form

To update the form's Design view with the graph's actual data, you must activate Microsoft Graph while the actual data is being charted in Form view. To view actual data in the chart in Design view of the form, follow these steps:

1. Create the graph on the form.

2. Set the graph's Enabled property to Yes and Locked property to No.

3. Close and save the form.

4. Open the form in Form view.

5. Click the Graph object so it has the focus.

6. On the Edit menu, point to Chart Object and then click Open to start Microsoft Graph.

7. Note that Microsoft Graph displays the actual data.

8. On the File menu, click Update.

9. On the File menu, click Exit & Return to <FormName> (where <FormName> is the name of your form).

10. Close the form.

11. Open the form in Design view. Note that the sample data has been replaced by the actual data.

Report

Because Microsoft Graph objects cannot be activated during print preview, there is no way to directly update reports with the actual charted data. In order to see the actual charted data in Design view of reports, you must first create the graph in a form, follow the previous steps in the "Form" section to view the actual data in the form, and then copy and paste the updated graph object into your report.

NOTE: The actual charted data shown in Design view of reports is static. Reports cannot automatically update graphs in Design view as forms can. each time you want to see the latest charted data in Design view of the report you must follow the steps in the "Form" section and then copy and paste the updated graph object into your report.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem