Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 303269 - Last Review: January 31, 2007 - Revision: 3.1
ACC97: Sorting and Grouping Dialog Box Does Not Appear
This article was previously published under Q303269
Novice: Requires knowledge of the user interface on single-user computers.
For a Microsoft Access 2000 version of this article, see
302506Â
(http://kbalertz.com/Feedback.aspx?kbNumber=302506/EN-US/
)
.
IMPORTANT: This article contains information about modifying the registry. Before you
modify the registry, make sure to back it up and make sure that you understand how to restore
the registry if a problem occurs. For information about how to back up, restore, and edit the
registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986Â
(http://kbalertz.com/Feedback.aspx?kbNumber=256986/EN-US/
)
Description of the Microsoft Windows Registry
SYMPTOMS
When you try to access the
Sorting and Grouping dialog box in a report, it does not appear.
CAUSE
This behavior may occur if the
Sorting and Grouping dialog box has been moved completely off the screen.
RESOLUTION
Use one of the following two methods to resolve this issue.
Method 1: Manually Move the Sorting and Grouping dialog box
Use the arrow keys to move the window back onto the screen. To do so, follow these steps:
- Start Microsoft Access.
- Open your database.
- Open a report in Design view.
- On the View menu, click Sorting and Grouping so that the Sorting and Grouping dialog box becomes the active window (although it is not visible).
- Press ALT+SPACEBAR to activate the window's system menu.
- Press the M key on your keyboard to notify the window that the arrow keys will be used to move the window manually. Note that the mouse pointer turns into a crosshair.
- Use the arrow keys to move the window around. You may have to work at this a while because you may not know where the window is. For example, if the window is off the top of the screen, pressing the UP ARROW key moves it farther off the screen.
- When you see the outline of the Sorting and Grouping dialog box, press ENTER to make the contents of the dialog box visible.
Method 2: Edit the Registry
The following technique causes the
Sorting and Grouping dialog box to reset to its default window settings. To do this, follow these steps.
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may
require you to reinstall your operating system. Microsoft cannot guarantee that you can solve
problems that result from using Registry Editor incorrectly. Use Registry Editor at your own
risk.
- Quit Microsoft Access.
- Click Start, and then click Run.
- In the Run dialog box, type regedit, and then click OK.
- Browse to the following key:
HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings
- In the right pane of Registry Editor, click the value SGST.
- On the Edit menu, click Delete.
- When you are prompted for confirmation to delete the value, click Yes.
- On the Registry menu, click Exit.
- Start Microsoft Access, and then open your database.
- Open a report in Design view, and verify that you can open the Sorting and Grouping dialog box.
APPLIES TO
- Microsoft Access 97 Standard Edition
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please