Microsoft KB Archive/174538

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

Article ID: 174538

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q174538



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



SYMPTOMS
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.

If you click OK, the Chart Wizard removes all of the fields from all of the controls.



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.



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.

