ACC1x: Screen Redraw Problems When Reordering Groups

ID: Q95926

The information in this article applies to:

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 
Issue type        : kbbug

Last Reviewed: March 19, 1999