Home Library Learn Downloads Support Community
Sign in | United States - English | |
3 out of 8 rated this helpful - Rate this topic

Customizing Menus and Shortcut Keys

SQL Server 2005

A keyboard accelerator allows you to select a menu command or button by pressing ALT+<single letter>. For example, to open the Edit menu, press ALT+E. You can rearrange and modify toolbar buttons, menus, and menu commands by using the Customize dialog box. Instructions are provided for changing the settings using the mouse and using only the keyboard.

Keyboard accelerators for stored procedures using the Ctrl key can be created from the Keyboard page of the Tools/Options dialog box.

ms174178.note(en-US,SQL.90).gifNote:
Click Collapse All at the top of this page to show only the headings.

To access the dialog box for assigning or changing a keyboard accelerator (using the mouse)

  1. On the Tools menu, click Customize.

  2. Make sure the toolbar you want to change is visible.

    1. In the Customize dialog box, click the Toolbars tab.
    2. Select the check box for the toolbar you want to display.

  3. In the Customize dialog box, click the Commands tab.

To assign or change a toolbar button's keyboard accelerator (using the mouse)

  1. Click the button on the toolbar.

  2. In the Customize dialog box, on the Commands tab, click Modify Selection.

  3. In the Name box on the shortcut menu, type a name for the toolbar button with an ampersand (&) before the letter that you want as the keyboard accelerator.

  4. Press ENTER.

  5. In the Customize dialog box, click Close.

To assign or change a menu command's keyboard accelerator (using the mouse)

  1. Click the menu name on the menu bar or toolbar.

  2. Click the menu command.

  3. In the Customize dialog box, click Modify Selection.

  4. In the Name box on the shortcut menu, type a name for the menu command with an ampersand (&) before the letter that you want as the keyboard accelerator.

  5. Press ENTER.

  6. In the Customize dialog box, click Close.

To access the dialog box for assigning or changing a keyboard accelerator (using the keyboard)

  1. Press ALT+T, then type C, to open the Customize dialog box.

  2. Make sure the toolbar you want to change is visible.

    1. In the Customize dialog box, press ALT+B to show the Toolbars tab.
    2. Use the arrow keys to select the toolbar you want to display, then SPACE to select the check box.

  3. In the Customize dialog box, press ALT+C to display the Commands tab.

To assign or change a toolbar button's keyboard accelerator (using the keyboard)

  1. Press ALT+R to display the Rearrange Commands dialog box.

  2. In the Rearrange Commands dialog box, use the arrow keys to select Toolbar.

  3. Tab to the Toolbar list, and use the arrow keys to select the toolbar that contains the button you want to change, and then press ENTER.

  4. Tab to the Controls list, and use the arrow keys to select the button you want to change.

  5. Press ALT+M, to select Modify Selection.

  6. Tab to the Name box on the shortcut menu, type a name for the toolbar button with an ampersand (&) before the letter that you want as the keyboard accelerator.

  7. Press ENTER.

  8. Tab to the Close button, and then press ENTER.

To assign or change a menu command's keyboard accelerator (using the keyboard)

  1. Press ALT+R to display the Rearrange Commands dialog box.

  2. Tab to Menu Bar and then use the arrow keys you click the menu you want in the Menu Bar list, and then press ENTER.

  3. Tab to the Controls list, and use the arrow keys to select the button you want to change.

  4. Press ALT+M, to select Modify Selection.

  5. Tab to the Name box on the shortcut menu, and type a name for the toolbar button with an ampersand (&) before the letter that you want as the keyboard accelerator.

  6. Press ENTER.

  7. In the Customize dialog box, click Close.

To create a keyboard accelerator for a stored procedure

  1. On the Tools menu, click Options.

  2. On the Keyboard page, select an unused keyboard combination in the Shortcut list.

  3. In the Stored Procedure box, type the stored procedure name, and then click OK.

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Modify Selection button is never active

Hi,

I've been struggling with this for longer than I care to admit. All I wanted to do was create short-cut keys for navigating bookmarks strictly within the current document (Edit.Bookmarks.Next Bookmark in Document, etc.) which do not have any short-cut keys associated with them by default. All of the instructions are telling me to perform some steps, then click "Modify Selection" when in fact that button appears to be disabled for everything I have tried. I am frustrated with the user interface that does show a "Keyboard..." button that, honestly, seems to be the more obvious place to put this functionality, yet it only supports 2 dozen hot-keys. I've been using SQL Studio 2005 for 6+ months now and find this to be quite odd and a very disappointing user experience from this tool.

Rich

[Tai Yee - MSFT] Hi, not sure why the button is not enabled for you. You may want to post this quesiton to the SQL Server Forums. The Forums are the best way to get questions answered The SQL Server Forums are located here: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1. You will likely want to post this to the Disaster Recovery & Availability forum.

History