ACC97: Chart Object Shrinks After Activating Microsoft Graph

• Microsoft Access 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

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)

1. Open the form or report with the chart on it in Design view.

2. Double-click on the chart object to open Microsoft Graph.

3. Resize the chart window to the correct size.

4. Close Microsoft Graph to return to Microsoft Access.

5. On the File menu, click Save.

Method 2: In-place Activation of the Chart (forms only)

1. Open the form with the chart on it in Design view.

2. Select the chart object.

3. On the View menu, click Properties.

4. Set the following properties for the Chart control:

        Enabled: Yes
        Locked: No
   

5. On the View menu, click Form View.

6. Double-click on the chart to activate the object.

7. Resize the frame around the chart to the appropriate size.

8. On the File menu, click Save.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 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 Behavior

1. Start Microsoft Access and open the sample database Northwind.mdb.

2. In the Database window, select the Sales By Category report, and then click Design.

3. Double-click the chart object to activate the Microsoft Graph OLE Server. The chart now appears in Graph.

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

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