Can't see the "Sorting & Grouping" dialog box 1

[XeroLui]

Dear all,
I've press the "Sorting & Grouping" button but the dialog box didn't shown up, why?

 

[XeroLui]

Moreover, I'm using Access 97.

 

[JaneC]

Hello,

I had this problem a while ago. Try looking it up in Technet if you have it - I'm fairly sure this was a registry setting.

I will try to have a look later today.

Jane

 

[JaneC]

Solution !

1. Verify that a backup file of the registry exists.

For additional information about the registry, please see the following articles
in the Microsoft Knowledge Base:

Q183887 Description of the Windows Registry Checker Tool (Scanreg.exe)

Q183603 How to Customize Registry Checker Tool

2. On the taskbar, click Start, and then click Run.

3. Type "regedit" (without the quotation marks) in the Run dialog box. Click OK.

4. Browse to the following key:

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings

5. Delete the key corresponding to the window that is orphaned:

+-----------------------------------------------+
| Window | Key |
+-----------------------------------------------+
| Table Properties | TDPopPropST |
+-----------------------------------------------+
| Table Indexes | IndexesST |
+-----------------------------------------------+
| Query Properties | QueryPopPropST |
+-----------------------------------------------+
| Form Properties | FormPopPropST |
+-----------------------------------------------+
| Report Properties | ReportPopPropST |
+-----------------------------------------------+
| Report Sorting and Grouping | SGST |
+-----------------------------------------------+
| Form or Report Field List | ECLST |
+-----------------------------------------------+



In your case delete the SGST key and this should solve the problem.

 

[XeroLui]

Dear Jane,
Thank you for your support. I've deleted the key SGST and the Access back to normal now.