Sorting and Grouping window in reports design doesn't Pop up

[CHTHOMAS]

Hello,<br><br>My Sorting and Grouping window in reports design doesn't Pop up. I tried going to View-&gt;Sorting and Grouping. Also i tried Clicking the Tool Button. No error messages and nothing. This problem arises only in my machine. I was getting it correctly till yesterday. Did i accidently set any properties of my MS Access? The sorting and grouping window Pops up for the same database and for the same report when i use another user's machine. Please help.<br><br>Regards and Thanks<br><br>Charley

 

[tripdad]

Charley, I also have had and now have this problem as well.&nbsp;&nbsp;The first time this occurred, our IS folks were able to reinstall Access 97 and the problem was fixed.&nbsp;&nbsp;The second time it occurred, they had to remove my entire Microsoft Office 97 and the associated registry files.&nbsp;&nbsp;I'm scared to think what they might have to do this time.&nbsp;&nbsp;I noticed that this problem popped up after Access locked up during the creation of a new report using the report wizard.&nbsp;&nbsp;I was also wondering if there was a setting that I could easily reset to get this feature to return.<br><br>Don

 

[CHTHOMAS]

Search the following Article ID IN Microsoft. It describes the Steps to edit the registry and solves the problem in 1 minute. (It is very easy if you copy and pase the SGST value from another users Machine)<br><br>Article ID-Q200412<br><br>Regards<br><br>Charley Thomas

 

[tripdad]

Charley, thanks for the tip.&nbsp;&nbsp;I also found an alternate way for accomplishing the same thing.&nbsp;&nbsp;It appears that the Sorting and Grouping box is still there, it is just so far off the screen that we can't see it (another little Access bug).&nbsp;&nbsp;Although this example is for the Sorting and Grouping pop-up window, it also applies to other Access pop-up windows as well.<br><br>Open your report in design mode.&nbsp;&nbsp;Select View from the menu.&nbsp;&nbsp;Make sure the Sorting and Grouping button looks pressed.&nbsp;&nbsp;If not, click it to open the Sorting and Grouping box.&nbsp;&nbsp;If you still cannot see it, press ALT SPACE, release the SPACE bar and then while still holding the ALT key down, press M.&nbsp;&nbsp;This will allow you to use the arrow keys to move the property box to a place where you can see it.<br><br>I tried this approach this morning and it worked.<br><br>Thanks again for the tip.<br><br>Don