Microsoft KB Archive/174538
Article ID: 174538
Article Last Modified on 1/20/2007
- Microsoft Access 97 Standard Edition
This article was previously published under Q174538
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:
If you click OK, the Chart Wizard removes all of the fields from all of the controls.
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.
If you want to change the chart, you must restart the Chart Wizard.
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb, click the Forms tab, and then click New.
- Select the Chart Wizard.
- Click the drop-down box, select the Products table from the list, and then click OK.
- When the Chart Wizard opens, under Available Fields, click ProductId and, then click the single right arrow.
- Click ProductName, and then click the right arrow.
- Click UnitPrice, and then click the right arrow.
- Click UnitsinStock, and then click the right arrow.
- Click Next.
- Leave the default chart type as the choice, and then click Next.
- Drag ProductName from the right axis so that it is removed from the control.
- Drag UnitsInStock under SumofUnitPrice in the Data section, and then click Next.
- 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.
For more information about using the Chart Wizard, search the Help Index for "Chart wizard," or ask the Microsoft Access 97 Office Assistant.
Additional query words: prb object doesn t support this property or method
Keywords: kberrmsg kbprb KB174538