## ACC1x: Run-Time Version Partially Displays Sorting And Grouping

Q101373

The information in this article applies to:

- Microsoft Access Distribution Kit, version 1.1

## SYMPTOMS

In the run-time version of Microsoft Access, a report's Sorting And Grouping dialog box is partially displayed. You can see the box's title bar, as well as the title bar of the Group Properties section.

## RESOLUTION

If you create an application for distribution, and you want to change the sorting and grouping properties for a report in the application without allowing the user to see the dialog box, set the Echo action's Echo On argument to No, so that the screen is not updated while the macro is running.
You can also prevent users from switching to Design view by using macros and forms to control what actions the user can take while in the application.

## STATUS

Microsoft has confirmed this to be a problem in the Microsoft Access Distribution Kit version 1.1. This problem no longer occurs in the Microsoft Access Developer's Toolkit version 2.0.

## MORE INFORMATION

### Steps to Reproduce Problem

1. In the sample database NWIND.MDB, create the following macro:

             Macro Name     Action
             -----------------------
             Test1        OpenReport
                          DoMenuItem

             Test1 Actions:
             --------------------------------
             OpenReport
                Report Name: Catalog
                View: Design
             DoMenuItem
                Menu Bar: Report
                Menu Name: View
                Command: Sorting And Grouping

2. Save this macro as AUTOEXEC. Close the database and quit Microsoft Access.
3. Start the run-time version of Microsoft Access with NWIND.MDB. To do this, switch to Program Manager and choose Run from the File menu. Type the following in the command line:
   C:\ACCESS\MSARN110.EXE NWIND.MDB
   Note that the Sorting And Grouping dialog box is partially displayed. As you tab through the dialog box, cells that contain text are visible.

## REFERENCES

For information about other methods of sorting and grouping reports, search for "GroupHeader," "GroupFooter," "GroupInterval," or "GroupOn" using the Microsoft Access Help menu.

Additional query words: runtime run-time

Keywords : kbusage
Issue type : kbbug
Technology :

Last Reviewed: November 4, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use.