ACC1x: Screen Redraw Problems When Reordering Groups

 Last reviewed: May 14, 1997
Article ID: Q95926
The information in this article applies to:
  • Microsoft Access version 1.0

SYMPTOMS

In a report, when you change the order of two group levels and the headers or footers have different heights, Microsoft Access does not redraw the screen completely, making further editing of the sections difficult.

RESOLUTION

Close the report and reopen it to force Microsoft Access to redraw the screen correctly.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem no longer occurs in Microsoft Access version 1.1.

MORE INFORMATION

The following Steps use the Employee Sales by Country Report from the NWIND.MDB sample database. In this report, the Salesperson and Country footers do not have identical heights.

Steps to Reproduce Problem

In the sample database NWIND.MDB:

  1. Open the Employee Sales by Country Report in Design view.

  2. Choose Sorting and Grouping... from the View menu to view the sorting and grouping levels.

  3. Move Salesperson above Country so that the Report will group by Salesperson first, then Country.

  4. Close the Sorting and Grouping box.

Note that while the two group headers and footers changed places, Microsoft Access did not redraw the screen completely. As a result, you cannot click the page footer because the Salesperson footer remains highlighted.

REFERENCES

Microsoft Access "User's Guide," version 1.0, Chapter 19, "Sorting and Grouping Data," pages 450-464

Keywords : kbusage RptSort
Version : 1.0
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.