کیلید های میانبر

[saber110]

سلام چگونه می توان برای دکمه های بکار گرفته شده فرم ها
از کیلدهای میانبر مثل ctrl+n استفاده نمود.

[majid325]

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
'33 - PgUp; 34 - PgDown; 18=Alt
Select Case KeyCode
Case 33, 34, 18
KeyCode = 0
Case Else
End Select

End Sub
با نمونه بالا و یه کم سلیقه هر Event ی رو که بخوای میتونی فعال یا غیر فعال کنی.

[شاپرک]

اینم کلید های میانبر :
Displaying Help
Display the Office Assistant and Microsoft Office help; context-sensitive Help about the selected property, CTRL, macro action, or Visual Basic keyword; or alerts with a Help button F1
Display ScreenTips in a dialog box, after selecting the option by using the keyboard SHIFT-F1

Opening Databases
Open a New Database CTRL-N
Open an Existing Database CTRL-O

Printing and Saving
Print the Current or Selected Object CTRL-P
Save a Database Object CTRL-S or SHIFT-F12
ALT-SHIFT-F2
Open the "Save As" Dialog Box F12 or ALT-F2

Using a Combo Box or List Box
Open a Combo Box ALT-DOWN ARROW or F4
Refresh the Contents of a lookup field list box or combo box F9
Move down one line DOWN ARROW
Move down one page PAGE DOWN
Move up one line UP ARROW
Move up one page PAGE UP
Exit the List Box or Combo Box TAB

Finding and Replacing Text or Data
Open the Find property sheet in the find and replace dialog (datasheet and form view only) CTRL-F
Open the replace property sheet of the find and replace dialog (datasheet and form view only) CTRL-H
Find the next occurance of the text specified in the find and replace dialog when the dialog box is closed (datasheet and form view only)

Working in Design View
Switch between edit and navigation mode (with insertion point displayed) F2
Switch to form view from form design view F5
Switch between the upper and lower portions of a window (Design view of tables, macros, and queries and the Advanced Filter/Sort window only) F6


Editing Controls in Form and Report Design View
Add a CTRL to a Section ALT-Enter
Copy the selected CTRL to the Clipboard CTRL-C
Cut the selected CTRL and copy it to the Clipboard CTRL-X
Paste the contents of the Clipboard in the upper-left corner of the selected section CTRL-V
Move the selected CTRL to the right CTRL-RIGHT ARROW
Move the selected CTRL to the left CTRL-LEFT ARROW
Move the selected CTRL up CTRL-UP ARROW
Move the selected CTRL down CTRL-DOWN ARROW
Increase the height of the selected CTRL SHIFT-DOWN ARROW
Increase the width of the selected CTRL SHIFT-RIGHT ARROW
Reduce the height of the selected CTRL SHIFT-UP ARROW
Reduce the width of the selected CTRL SHIFT-LEFT ARROW

Window Operations
Bring the Database window to the front F11
ALT-F1
Cycle Among open windows CTRL-F6
Restore the selected minimized window when all windows are minimized Enter
\ CTRL-F8
Display the CTRL menu ALT-SPACEBAR
Display the shortcut menu SHIFT-F10
Close the active window CTRL-F4
CTRL-W
Switch between the Visual Basic Editor and the previous active window ALT-F11
Switch between the Microsoft Script Editor and the previous active window ALT-SHIFT-F11

Miscellaneous
Display the complete hyperlink address for a selected hyperlink F2
Check spelling F7
Open the Zoom box to conveniently enter expressions and other text in small input areas SHIFT-F2
Display a property sheet in Design view ALT-Enter
Quit Microsoft Access, close a dialog box, or close a property sheet ALT-F4
Invoke a Builder CTRL-F2
Toggle between a custom menu bar and a built-in menu bar CTRL-F11

Editing and navigating the Object list in a Database Window
Rename a selected object F2
Move down one line DOWN ARROW
Move down one window PAGE DOWN
Move to the last object END
Move up one line UP ARROW
Move up one window PAGE UP
Move to the first object HOME

Navigating and Opening Objects in a Database Window
Cycle through the Objects bar top to bottom CTRL-TAB
Cycle through the Objects bar bottom to top CTRL-SHIFT-TAB
Open the selected table or query in Datasheet view, or form in Form view Enter or ALT-O
Open the selected report in Print Preview Enter
Open the selected data access page in Page view Enter
Run the selected macro Enter
Open the selected table, query, form, report, data access page, macro, or module in Design view CTRL-Enter
ALT-D
Create a new table, query, form, report, data access page, macro, or module ALT-N
Refresh the Database window F5
Display the Immediate window in the Visual Basic Editor CTRL-G

Using Menus
Show the shortcut menu SHIFT-F10
Make the menu bar active F10
Show the program icon menu (on the program title bar) ALT-SPACEBAR
With the menu or submenu is visible, to select the next or previous command UP ARROW
DOWN ARROW
Select the menu to the left or right; or, when a submenu is visible, to switch between the main menu and the submenu LEFT ARROW
RIGHT ARROW
Select the first or last command on the menu or submenu HOME
END
Close the visible menu and submenu at the same time ALT
Close the visible menu; or, with a submenu visible, to close the submenu only Escape

Working in Toolbars
Make the menu bar active F10
Select the next or previous toolbar CTRL-TAB
CTRL-SHIFT-TAB
When a toolbar is active, to select the next or previous button or menu on the toolbar TAB
SHIFT-TAB
When a menu on a toolbar is selected, to open the menu Enter
When a button is selected, to perform the action assigned to a button Enter
When the text box is selected, to enter text in a text box Enter
When a drop-down list box or drop-down menu on a button is selected, to move through options in the list or menu; then press ENTER to select the option you want Up
DOWN ARROW
using a Window
Switch to the next program ALT-TAB
Switch to the previous program ALT-SHIFT-TAB
Show the Windows Start menu CTRL-ESCAPE
Close the active database window CTRL-W
Switch to the next database window CTRL-F6
Switch to the previous database window CTRL-SHIFT-F6

Using a dialog box
Switch to the next property sheet in a dialog box CTRL-TAB
CTRL-PAGE DOWN
Switch to the previous property sheet in a dialog box CTRL-SHIFT-TAB
CTRL-PAGE UP
Move to the next option or option group TAB
Move to the previous option or option group SHIFT-TAB
Move between options in the selected drop-down list box, or to move between some options in a group of options Arrow Keys
Perform the action assigned to the selected button; select or clear the check box SPACEBAR
The first letter in the option name you want (when a drop-down list box is selected) To move to the option by the first letter in the option name in a drop-down list box Letter key
Select the option, or to select or clear the check box by the letter underlined in the option name ALT-Letter Key
Open the selected drop-down list box ALT-DOWN ARROW
Close the selected drop-down list box ESCAPE
Perform the action assigned to the default button in the dialog box ENTER
Cancel the command and close the dialog box ESCAPE
Editing in a Text Box
Move to the beginning of the entry HOME
Move to the end of the entry END
Move one character to the left or right LEFT OR RIGHT ARROW
Move one word to the left or right CTRL-Left
RIGHT ARROW
Select from the insertion point to the beginning of the entry SHIFT-HOME
Select from the insertion point to the end of the entry SHIFT-END
Select one character to the left SHIFT-LEFT ARROW
Select one character to the right SHIFT-RIGHT ARROW
Select one word to the left CTRL-SHIFT-LEFT ARROW
Select one word to the right CTRL-SHIFT-RIGHT ARROW

Keys for - Open, File New Database and Export Dialog Boxes
Go to the previous folder ALT-1
Open the folder up one level from the open folder (Up One Level button ) ALT-2
Close the dialog box, and open your World Wide Web search page (Search the Web button ) ALT-3
Delete the selected folder or file DELETE
Create a new subfolder in the open folder (Create New Folder button ) ALT-5
Switch between List, Details, Properties, and Preview views ALT-6
Show the Tools menu (Tools button) ALT-7

Get Help from the Office Assistant
In order to use these commands, the Office Assistant must be Enabled and Visible
if the Assistant is showing. Display the Assistant balloon F1
Select a Help topic from the list the Assistant displays ALT-number (ALT-1 is the first topic, ALT-2 is the second, and so on)
See more Help topics ALT-DOWN ARROW
Previous Help topics ALT-UP ARROW
Close an Assistant message Escape

Working in the Help Window
Move between the navigation pane and topic pane F6
Display the Options menu to access any Help toolbar command ALT-O
Display the program control menu ALT-SPACEBAR
Close the active Help window ALT-F4

Move Around in the Navigation Pane of the Help Window
Switch to the next tab Conrol-TAB
Switch to the previous tab CTRL-SHIFT-TAB
Switch to the Contents tab ALT-C
Switch to the Answer Wizard tab ALT-A
Switch to the Index tab ALT-I
Open or close a selected book, or open a selected Help topic Enter
Select the next book or Help topic DOWN ARROW
Select the previous book or Help topic UP ARROW

Move Around in the Topic Pane of the Help Winodw
Go back to a Help topic you viewed previously ALT-LEFT ARROW
Go forward to a Help topic you viewed previously ALT-RIGHT ARROW
Go to the first or next hyperlink TAB
Go to the last or previous hyperlink SHIFT-TAB
Activate a selected hyperlink Enter
Close a pop-up window Escape
Scroll toward the beginning of a Help topic UP ARROW
Scroll toward the end of a Help topic DOWN ARROW
Scroll toward the beginning of a Help topic in larger increments PAGE UP
Scroll toward the end of a Help topic in larger increments PAGE DOWN
Move to the beginning of a Help topic HOME
Move to the end of a Help topic END
Print the active Help topic CTRL-P
Select the entire Help topic CTRL-A
Copy the selected items to the Clipboard CTRL-C

Sending E-mail Messages
Send the active database object as an e-mail message ALT-F-D-A
Open the Address Book CTRL-SHIFT-B
Check the names in the To, Cc, and Bcc boxes against the Address Book ALT-K
Select the next box in the e-mail header or the body of the message when the last box in the e-mail header is active TAB
Select the previous field or button in the e-mail header SHIFT-TAB

Selecting Text in a field
Extend one character to the right SHIFT-RIGHT ARROW
Extend one word to the right CTRL-SHIFT-RIGHT ARROW
Extend one character to the left SHIFT-LEFT ARROW
Extend one word to the left CTRL-SHIFT-LEFT ARROW
To cancel a selection, use the opposite arrow key.

Selecting a Field or Record
Select the next field TAB
Switch between Edit mode (with insertion point displayed) and Navigation mode F2
Switch between selecting the current record and the first field of the current record, in Navigation mode SHIFT-SPACEBAR
Extend selection to the previous record, if the current record is selected SHIFT-UP ARROW
Extend selection to the next record, if the current record is selected SHIFT-DOWN ARROW
Select all records CTRL-A
CTRL-SHIFT-SPACEBAR

Select Fields and Records in Datasheet View
Turn on Extend mode (EXT appears in the lower-right corner of the window); pressing F8 repeatedly extends the selection to the word, the field, the record (in Datasheet view only), and all records F8
Extend a selection to adjacent fields in the same row in Datasheet view LEFT ARROW
RIGHT ARROW
Extend a selection to adjacent rows in Datasheet view Up ARROW
DOWN ARROW
Undo the previous extension SHIFT-F8
Cancel Extend mode ESCAPE

Selecting and Moving a Column in Datasheet View
Select the current column or cancel the column selection, in Navigation mode only CTRL-SPACEBAR
Select the column to the right, if the current column is selected SHIFT-RIGHT ARROW
Select the column to the left, if the current column is selected SHIFT-LEFT ARROW
Turn on move mode; then press the RIGHT ARROW or LEFT ARROW key to move selected column(s) to the right or left CTRL-SHIFT-F8

Moving the Insertion Point in a Field
If the insertion point isn't visible, press F2 to display it.
Move it one character to the right RIGHT ARROW
Move one word to the right CTRL-RIGHT ARROW
Move one character to the left LEFT ARROW
Move one word to the left CTRL-LEFT ARROW
Move to the end of the field, in single-line fields END
Move to the end of the field, in multiple-line fields CTRL-END
Move to the beginning of the field, in single-line fields HOME
Move to the beginning of the field, in multiple-line fields CTRL-HOME

Copying, Moving, or Deleting Text
Copy the selection to the Clipboard CTRL-C
Cut the selection and copy it to the Clipboard CTRL-X
Paste the contents of the Clipboard at the insertion point CTRL-V
Delete the selection or the character to the left of the insertion point Backspace
Delete the selection or the character to the right of the insertion point DELETE
Delete all characters to the right of the insertion point CTRL-DELETE

Undoing Changes
Undo typing CTRL-Z
ALT-Backspace
Undo changes in the current field or current record; if both have been changed, press ESC twice to undo changes, first in the current field and then in the current record Escape

Entering Data in Datasheet or Form View
Insert the current date CTRL-SEMICOLON (;)
Insert the current time CTRL-COLON (:)
Insert the default value for a field CTRL-ALT-SPACEBAR
Insert the value from the same field in the previous record CTRL-APOSTROPHE (')
Add a new record CTRL-PLUS (+)
Delete the current record CTRL-MINUS (-)
Save changes to the current record SHIFT-ENTER
Switch between the values in a check box or option button SPACEBAR
Insert a new line CTRL-ENTER

Refreshing Fields with Current Data
Recalculate the fields in the window F9
Requery the underlying tables; in a subform, this requeries the underlying table for the subform only SHIFT-F9
Refresh the contents of a Lookup field list box or combo box F9

Navigating in Datasheet View
Move to the record number box; then type the record number and press ENTER F5
Move to the next field TAB
RIGHT ARROW
Move to the last field in the current record, in Navigation mode END
Move to the previous field SHIFT-TAB
LEFT ARROW
Move to the first field in the current record, in Navigation mode HOME
Move to the current field in the next record > DOWN ARROW
Move to the current field in the last record, in Navigation mode CTRL-DOWN ARROW
Move to the last field in the last record, in Navigation mode CTRL-END
Move to the current field in the previous record UP ARROW
Move to the current field in the first record, in Navigation mode CTRL-UP ARROW
Move to the first field in the first record, in Navigation mode CTRL-HOME

Navigating to Another Screen of Data
Go down one screen PAGE DOWN
Go up one screen PAGE UP
Go right one screen CTRL-PAGE DOWN
Go left one screen CTRL-PAGE UP

Selecting Fields and Records in Datasheet View
To select data within a field Move the insertion point to the start of the text you want to select, and then hold down SHIFT and press the arrow keys to move to the END of the se
To select an entire field Move the insertion point to the field, and press F2. Adjacent fields With a field selected, hold down SHIFT and press the appropriate arrow key.
To select the current column Cntrol-SPACEBAR
To select the current record SHIFT-SPACEBAR
To select multiple records SHIFT-SPACEBAR, and then SHIFT-Up or DOWN ARROW.

Navigating in Subdatasheets
Move to a specific record F5 from the subdatasheet to move to the record number box; then type the record number and press Enter
Expand the record’s subdatasheet CTRL-SHIFT-DOWN ARROW from within the datasheet
Collapse the subdatasheet CTRL-SHIFT-UP ARROW from within the datasheet
Enter the subdatasheet from the last field of the previous record in the datasheet TAB
Enter the subdatasheet from the first field of the following record in the datasheet SHIFT-TAB
Exit the subdatasheet and move to the first field of the next record in the datasheet CTRL-TAB
Exit the subdatasheet and move to the last field of the previous record in the datasheet CTRL-SHIFT-TAB
Enter the next field in the datasheet TAB from the last field in the subdatasheet
Bypass the subdatasheet and move to the next record in the datasheet DOWN ARROW
Bypass the subdatasheet and move to the previous record in the datasheet UP ARROW
You can navigate between fields and records in a subdatasheet with the same shortcut keys used in Datasheet view.

navigating in Form View
Moving to a specific record F5 To move to the record number box; then type the record number and press Enter
Move to the next field TAB
Move to the previous field SHIFT-TAB
Move to the last field in the current record, in Navigation mode END
Move to the last field in the last record, in Navigation mode CTRL-END
Move to the first field in the current record, in Navigation mode HOME
Move to the first field in the first record, in Navigation mode CTRL-HOME
Move to the current field in the next record CTRL-PAGE DOWN
Move to the current field in the previous record CTRL-PAGE UP

Navigating in Forms with More than One Page
Go down one page; at the end of the record, moves to the equivalent page on the next record PAGE DOWN
Go up one page; at the end of the record, moves to the equivalent page on the previous record PAGE UP

Navigating between the Main Form and Subform
Enter the subform from the preceding field in the main form TAB
Enter the subform from the following field in the main form SHIFT-TAB
Exit the subform and move to the next field in the master form or next record CTRL-TAB
Exit the subform and move to the previous field in the main form or previous record CTRL-SHIFT-TAB

Dialog Box and Window Operations in Print Preview and Layout Preview
Use shortcut keys in Print Preview and Layout Preview
Open the Print dialog box P
CTRL-P
Open the Page Setup dialog box S
Zoom in or out on a part of the page Z
Cancel Print Preview or Layout Preview C
ESCAPE
Move to the page number box; then type the page number and press ENTER F5
View the next page (when Fit To Window is selected) PAGE DOWN
DOWN ARROW
View the previous page (when Fit To Window is selected) PAGE UP
UP ARROW

Navigating a Database Diagram
Move from a table cell to the table’s title bar ESCAPE
Move from a table’s title bar to the last cell you edited ENTER
Move from table title bar to table title bar, or from cell to cell inside a table TAB
Expand a list inside a table ALT-DOWN ARROW
Scroll through the items in a drop-down list from top to bottom DOWN ARROW
Move to the previous item in a list UP ARROW
Select an item in a list and move to the next cell ENTER
Change the setting in a check box SPACEBAR
Go to the first cell in the row, or to the beginning of the current cell HOME
Go to the last cell in the row, or to the END of the current cell END
Scroll to the next "page" inside a table, or to the next "page" of the diagram PAGE DOWN
Scroll to the previous "page" inside a table, or to the previous "page" of the diagram PAGE UP

Navigating in the Query Designer
Move Among the Query Designer Panes F6
SHIFT-F6

[شاپرک]

Diagram Pane
Move between input source windows (and to join lines if available) TAB
SHIFT-TAB
Move between columns in an input source window ARROW KEYS
Choose the selected data column for output SPACEBAR or PLUS (If multiple items are selected, pressing the SPACEBAR affects all selected items. Select multiple items by holding down the SHIFT key while clicking them. Toggle the selected state of a single item by holding down CTRL while clicking it.)
Remove the selected data query column from the query output SPACEBAR or Minus Key (If multiple items are selected, pressing the SPACEBAR affects all selected items. Select multiple items by holding down the SHIFT key while clicking them. Toggle the selected state of a single item by holding down CTRL while clicking it.)
Remove the selected input source or join the line from the query DELETE

Cut selected text in a cell to the Clipboard (in edit mode)

Grid Pane
Move among cells ARROW KEYS
TAB
SHIFT-TAB
Move to the last row in the current column CTRL-DOWN ARROW
Move to the first row in the current column CTRL-UP ARROW
Move to the first postion in the current cell or the first column in the input source window CTRL-HOME
Move to the last position in the current cell or the lst column in the input source window CTRL-END
Move in a drop-down list Up ARROW
DOWN ARROW
Select an entire grid column CTRL-SPACEBAR
Toggle between edit mode and cell selection mode F2
Copy selected text in a cell to the Clipboard (in edit mode) CTRL-C
Cut selected text in a cell to the Clipboard (in edit mode) CTRL-X
Paste text from Clipboard (in edit mode) CTRL-V
Toggle between insert and overstrike mode while editing within a cell INSERT
Toggle the checkbox in the output columns SPACEBAR
Clear the selected contents of a cell DELETE
Remove row containing selected data from the query DELETE
Cleear all values for a selected grid column DELETE
Insert row between existing row INSERT after you select grid row

Shortcut Keys for Page View
To use the following keys, press the TAB key repeatedly until the expand indicator or record navigation toolbar has focus. If a PivotTable list or spreadsheet control currently has focus, press CTRL-TAB
Expand or collapse a group of records corresponding to the expand indicator in a grouped data access page. SPACEBAR
ENTER
Select a button on the record navigation toolbar. LEFT ARROW
RIGHT ARROW
Activate the selected button on the record navigation toolbar. SPACEBAR or Enter

Data Access Page Design View
Add a control to a section SHIFT-Enter
Copy the selected control to the Clipboard CTRL-C
Cut the selected control and copy it to the Clipboard CTRL-X
Paste the contents of the Clipboard in the upper-left corner of the selected section CTRL-V
Move the selected control to the right by a pixel (irrespective of the page’s grid) CTRL-RIGHT ARROW
Move the selected control to the left by a pixel (irrespective of the page’s grid) CTRL-LEFT ARROW
Move the selected control up by a pixel (irrespective of the page’s grid) CTRL-UP ARROW
Move the selected control down by a pixel (irrespective of the page’s grid) CTRL-DOWN ARROW

Select Elements within a PivotTable List
Select each field and then the entire PivotTable list, going through these selections in sequence. TAB
Select the previous field or the entire PivotTable list. detail area or data area. SHIFT-TAB
Move the selection in the direction of the arrow key. If a row or column field is selected, press DOWN ARROW to move to the first item of data in the field, and then press an arrow key to move to the next or previous item or back to the field. If a detail field or an item of data is selected, press DOWN ARROW OR RIGHT ARROW to move to the first cell in the ARROW KEYS
Extend or reduce the selection in the direction of the arrow key. You can extend a selection down and to the right. SHIFT-RIGHT ARROW
Extend a selection down one screen. A screen is all of the data currently displayed in the PivotTable list. SHIFT-PAGE DOWN
Reduce a selection by one screen. SHIFT-PAGE UP
Select the field for the currently selected item of data, total, or detail cell. CTRL-SPACEBAR
Select the entire row containing the currently selected cell. SHIFT-SPACEBAR
Select the entire PivotTable list. CTRL-A
Display the next screen. A screen is all of the data currently displayed in the PivotTable list. PAGE DOWN
Display the previous screen. PAGE UP
Display the next screen to the right. ALT-PAGE UP
Display the previous screen to the left. ALT-PAGE DOWN
Display the shortcut menu for the selected element of the PivotTable list. Use the shortcut menus to carry out commands in the PivotTable list. SHIFT-F10
Carry out a command on the shortcut menu. See ALT+ENTER for information about the PivotTable Property Toolbox. UNDERLINED LETTER
Close the shortcut menu without carrying out a command. ESCAPE
Display or hide the toolbar. CTRL-7
Display the PivotTable Property Toolbox. No keyboard shortcuts are available to carry out commands or set properties from the toolbox. ALT-ENTER
Close the PivotTable Property Toolbox. ALT-F4
Refresh the PivotTable list from the source data. F9
Cancel a refresh in progress. ESCAPE
Copy the selected data from the PivotTable list to the Clipboard. CTRL-C
Export the PivotTable list to Microsoft Excel. CTRL-E

Display, Hide, Filter, and Sort Data in a PivotTable List
Display or hide the and expand indicators beside items. CTRL-8
Display detail for the currently selected item. CTRL-Plus Sign
Hide detail for the currently selected item. CTRL-Minus Sign
Open the drop-down list for the currently selected field. ALT-DOWN ARROW
Alternately move to the most recently selected item, the OK button, and the Cancel button in the drop-down list for a field. TAB
Move to the next item in the drop-down list for a field. ARROW KEYS
Select or clear the check box for the current item in the drop-down list for a field. SPACEBAR
Display lower levels of detail, if available, for the current item in the drop-down list for a field. PLUS SIGN (numeric keypad)
Hide lower levels of detail for the current item in the drop-down list for a field. MINUS SIGN (numeric keypad)
Close the drop-down list for a field, and apply any changes you made. ENTER
Close the drop-down list for a field without applying your changes. ESCAPE
Turn AutoFilter on or off. CTRL-T
Sort data in the selected field or total in ascending order (A – Z 0 – 9). CTRL-SHIFT-A
Sort data in the selected field or total in descending order (Z – A 9 – 0). CTRL-SHIFT-Z

Keys for Adding Fields and Totals
Add a new total field for the selected field in the PivotTable list by using the Sum summary function. CTRL-SHIFT-S
Add a new total field for the selected field in the PivotTable list by using the Count summary function. CTRL-SHIFT-C
Add a new total field for the selected field in the PivotTable list by using the Min summary function. CTRL-SHIFT-H
Add a new total field for the selected field in the PivotTable list by using the Max summary function. CTRL-SHIFT-X
Turn subtotals and grand totals on or off for the selected field in the PivotTable list. CTRL-SHIFT-B

Changing a Pivot Table Layout
Move the selected field in the PivotTable list to the row area. CTRL-1
Move the selected field in the PivotTable list to the column area. CTRL-2
Move the selected field in the PivotTable list to the filter area. CTRL-3
Move the selected field in the PivotTable list to the detail area. CTRL-4
Move the selected row or column field in the PivotTable list to a higher level. CTRL-LEFT ARROW
Move the selected row or column field in the PivotTable list to a lower level. CTRL-RIGHT ARROW

Format a PivotTable List
The first seven keyboard shortcuts in the following table change the number format of the selected element.
Apply the general number format to values in the selected total or detail field. CTRL-SHIFT-Tilde (~)
Apply the currency format, with two decimal places and negative numbers in parentheses, to values in the selected total or detail field. CTRL-SHIFT-5
Apply the percentage format, with no decimal places, to values in the selected total or detail field. CTRL-SHIFT-4
Apply the exponential number format, with two decimal places, to values in the selected total or detail field. CTRL-SHIFT-Carat (^)
Apply the date format, with the day, month, and year, to values in the selected total or detail field. CTRL-SHIFT-#3
Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field. CTRL-SHIFT-2
Apply the numeric format, with two decimal places, thousands separator, and a minus sign for negative values, to values in the selected total or detail field. CTRL-SHIFT-!
Make text bold in the selected element of the PivotTable list. CTRL-B
Make text underlined in the selected element of the PivotTable list. CTRL+ U
Make text italic in the selected element of the PivotTable list. CTRL-I

Activating, Moving Around, and Selecting in Spreadsheets
Selects cells in the spreadsheet. TAB
Select the previous cell in the spreadsheet. SHIFT-TAB
Move the selection in the direction of the arrow key. ARROW KEYS
Extend the selection in the direction of the arrow key. SHIFT-ARROW KEYS
Select the current column. CTRL-SPACEBAR
Select the current row. SHIFT-SPACEBAR
Extend a selection down one screen. A screen is all of the data currently displayed in the spreadsheet. SHIFT-PAGE DOWN
Extend a selection up one screen. A screen is all of the data currently displayed in the spreadsheet. SHIFT-PAGE UP
Move the selection to the first cell in the current row. HOME
Move the selection to cell A1 or the upper-left cell of the visible range. CTRL-HOME
Move the selection to the last cell in the spreadsheet that contains data and is not hidden by filtering. CTRL-END
Move the selection to the last cell in that direction of the current area containing data (the area of data bounded by blank rows and columns). CTRL-ARROW KEYS
Scroll in the direction of the arrow key. SCROLL LOCK-ARROW KEYS
Scroll down one screen. A screen is all of the data currently displayed in the spreadsheet. PAGE DOWN
Scroll up one screen. A screen is all of the data currently displayed in the spreadsheet. PAGE UP
Select all cells in the spreadsheet. CTRL-A

Carrying out Commands in a Spreadsheet
Display Help topics. F1
Display the shortcut menu for the spreadsheet. Shhift-F10
Carry out a command on the shortcut menu when the menu is displayed. See UNDERLINED LETTER
Information about the Spreadsheet Property Toolbox. ALT-ENTER
Close the shortcut menu without carrying out a command. ESCAPE
Display the Spreadsheet Property Toolbox. No keyboard shortcuts are available to carry out commands or set properties from the Spreadsheet Property Toolbox. ALT-ENTER
Close the Spreadsheet Property Toolbox. ALT-F4
Display or hide the toolbar for the spreadsheet. CTRL-7
Undo. Reverse the last command or DELETE the last entry you typed. CTRL-Z
Add numbers automatically with the SUM function. ALT-EQUAL
Turn AutoFilter on or off. CTRL-T
Export the spreadsheet to Microsoft Excel. CTRL-E
Recalculate the spreadsheet. F9

Entering, Editing, and Copying data in Spreadsheets
Edit the contents of the selected cell. F2
Enter data in the current cell. ENTER
Enter data in multiple selected cells. CTRL-ENTER
Cancel entering or changing data in a cell. ESCAPE
Clear the contents of the current cell. BACKSPACE
Clear the contents of the selected cells. DELETE
Remove the selected data from the spreadsheet and place the data on the Clipboard. CTRL-X
Copy the selected data from the spreadsheet to the Clipboard. CTRL-C
Insert the contents of the Clipboard at the insertion point, and replace any selected data. CTRL-V
Make text in the selected cells bold. CTRL-B
Make text in the selected cells underlined. CTRL-U
Make text in the selected cells italic. CTRL-I
Enter the euro currency symbol . ALT-0128 on the numeric keypad (NUM LOCK must be turned on)

Working with AutoFilter Drop-Down :Lsts in a Spreadsheet
Open the AutoFilter drop-down list for the selected cell. ALT-DOWN ARROW
Alternately move to the most recently selected item, the OK button, and the Cancel button in an AutoFilter drop-down list. TAB
Move to the next item in an AutoFilter drop-down list. ARROW KEYS
Move to the first item that starts with that letter or number in an AutoFilter drop-down list. LETTER or NUMBER KEYS
Extend the selection in an AutoFilter drop-down list. SHIFT-ARROW KEYS
Select or clear the check boxes for the selected items in an AutoFilter drop-down list. SPACEBAR
Close an AutoFilter drop-down list and apply any changes you made. ENTER
Close an AutoFilter drop-down list without applying your changes. ESCAPE

Place a Text Box or Another CTRL on a Form or Report
1. Press ALT
2. Press CTRL+TAB twice to put focus on the toolbox. (If the toolbox is not displayed, press CTRL-SHIFT-F10 to display the toolbar shortcut menu. Use the DOWN ARROW key to select Toolbox, and then press Enter. )
3. Press TAB repeatedly until you select the desired CTRL.
4. Press SHIFT-Enter to add the CTRL to the upper-left corner of the form or report detail section.
5. Make sure the CTRL is still selected, and press ALT-V-F to display the control's property sheet. Then, press CTRL-TAB to select the All TAB.
6. Adjust the Left and Top property settings to move the control to the desired location on the form or report, and then press ALT-F4 to close the property sheet. Alternatively, press CTRL-Any Arrow Key to manually move the CTRL and SHIFT-ANY ARROW KEY to resize the control as needed. Learn about

Copy a Text Box or another CTRL on a Form or Report
1. Press ALT
2. Press CTRL-TAB until the Object combo box on the Formatting (Form/Report) toolbar has the focus, and then press Enter.
3. Press F4 to open the Object combo box.
4. Press the DOWN ARROW key to select the control, and then press Enter.
5. Press Conrol-C to copy the control to the Clipboard.
6. Repeat steps 1 through 3 to open the Object combo box.
7. Press the DOWN ARROW key to select the section, and then press Enter.
8. Press CTRL-V to paste the control in the upper-left corner of the section. To paste multiple copies, press CTRL+V repeatedly.
9. To adjust the location of the control by using property settings, select the CTRL and press ALT-V-F to display the control's property sheet. Press CTRL-TAB to select the All TAB. Adjust the Left and Top property settings to move the control to the desired location on the form or report, and then press ALT+F4 to close the property sheet. Alternatively, press CTRL-ANY ARROW KEY to manually move the CTRL and SHIFT-ANY ARROW KEY to resize the control as needed. Learn about

Send a Data Access Page as the Body of an E-mail Message
1. A data access page is connected to an OLE DB data source, either a Microsoft Access database or Microsoft SQL Server database. For the data access page to work properly, the database must be available to users of the page. Learn about sharing the OLE DB data source of a page.
2. In the Database window, click Pages under Objects, and then the name of the page you want to send as the body of an e-mail message.
3. On the File menu, click Send To and then choose Mail Recipient.
4. Access opens the data access page in Page Design view so that you can make changes, such as adding text or notes to the data access page for the mail recipient, before you send the data access page.
5. Enter recipient names in the To and Cc boxes. Separate names with a semicolon (;)
6. To select recipient names from a list, click To or Cc. The name of the object is displayed in the Subject box by default, but you can type your own subject name. You can manually check names before sending the message. You can also set additional options for the e-mail message.
7. Click Send on the message header.

Rearrange Columns in Datasheet View
1. Move the insertion point to a field in the column of the datasheet or subdatasheet you want to move. Learn about navigating in a datasheet or navigating between a datasheet and subdatasheet.
2. If the entire field is not already highlighted, press F2.
3. To select the entire column, press CTRL-SPACEBAR. You can select more than one column by pressing SHIFT-LEFT ARROW or SHIFT-RIGHT ARROW . (This has to be done before you enter Move mode.)
4. To turn on Move mode, press CTRL-SHIFT-F8
5. To move the column to the right, press the RIGHT ARROW. .
6. To move the column to the left, press the LEFT ARROW.
7. To turn off Move mode, press ESCAPE