ACC97: Chart Wizard Gives Error After Changes Are Made to Design

• Microsoft Access 97

SYMPTOMS

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

When you click the Back button in the Chart Wizard to return to the Chart Design screen to modify a chart that contains multiple Data fields, you receive the following error message:

   Object doesn't support this Property or Method.

CAUSE

Once you have passed the Chart Design screen, Microsoft Access doesn't allow changes to be made to the chart design when the chart contains multiple Data fields.

RESOLUTION

If you want to change the chart, you must restart the Chart Wizard.

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb, click the Forms tab, and then click New.

2. Select the Chart Wizard.

3. Click the drop-down box, select the Products table from the list, and then click OK.

4. When the Chart Wizard opens, under Available Fields, click ProductId and, then click the single right arrow.

5. Click ProductName, and then click the right arrow.

6. Click UnitPrice, and then click the right arrow.

7. Click UnitsinStock, and then click the right arrow.

8. Click Next.

9. Leave the default chart type as the choice, and then click Next.

10. Drag ProductName from the right axis so that it is removed from the control.

11. Drag UnitsInStock under SumofUnitPrice in the Data section, and then click Next.

12. When the Chart Wizard dialog box asks for a title, click Back.

    You receive the error mentioned in the "Symptoms" section. Then, when you click OK, the chart has lost all fields in any of the controls. At this point, you must restart the Chart Wizard.

    NOTE: You can click the Back button on the Title screen if no changes have been made to the fields or if only one field is in the Data section. However, once multiple fields are in the Data section and you make changes to the design, you cannot go back.

REFERENCES

For more information about using the Chart Wizard, search the Help Index for "Chart wizard," or ask the Microsoft Access 97 Office Assistant.