Microsoft KB Archive/176237

From BetaArchive Wiki

Article ID: 176237

Article Last Modified on 1/22/2007


  • Microsoft Access 97 Standard Edition

This article was previously published under Q176237

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.


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.


Microsoft has confirmed this to be a problem in Microsoft Access 97.


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.


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