Article ID: 176237
Article Last Modified on 1/22/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q176237
Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
Each time that you open a chart object in Microsoft Graph, the window size of the chart shrinks in Microsoft Graph. When Microsoft Graph closes, it passes the new, smaller size back to the Microsoft Access chart object. Over time, this behavior cause the Microsoft Access chart object to become smaller and smaller.
RESOLUTION
To return the chart to the appropriate size, resize the chart window using either of the following methods.
Method 1: Opening Chart in Microsoft Graph (forms and reports)
- Open the form or report with the chart on it in Design view.
- Double-click on the chart object to open Microsoft Graph.
- Resize the chart window to the correct size.
- Close Microsoft Graph to return to Microsoft Access.
- On the File menu, click Save.
Method 2: In-place Activation of the Chart (forms only)
- Open the form with the chart on it in Design view.
- Select the chart object.
- On the View menu, click Properties.
Set the following properties for the Chart control:
Enabled: Yes Locked: No
- On the View menu, click Form View.
- Double-click on the chart to activate the object.
- Resize the frame around the chart to the appropriate size.
- On the File menu, click Save.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97.
MORE INFORMATION
Steps to Reproduce Behavior
- Start Microsoft Access and open the sample database Northwind.mdb.
- In the Database window, select the Sales By Category report, and then click Design.
- Double-click the chart object to activate the Microsoft Graph OLE Server. The chart now appears in Graph.
- Note the numerical values along the X axis. After you repeat the next step several times, you will see the last digit of each number wrap to the next line.
- Close Graph and repeat steps 3, 4, and 5 until you see the wrapping effect described in step 4.
REFERENCES
For more information about charts, search the Help Index for "charts," or ask the Microsoft Access 97 Office Assistant.
Additional query words: pra graph resize smaller
Keywords: kbbug KB176237