Microsoft Access keyboard shortcuts
Microsoft Access keyboard shortcuts
|
|
|
|
|
|
Description
|
Shortcut Key
|
To display a property sheet
|
Alt + Enter
|
|
|
To quit Microsoft Access, close a dialog
box, or
|
Alt + F4
|
close a property sheet
|
|
To toggle between breaking and not breaking
on
|
Alt + F5
|
unhandled errors and then step to the next
|
|
statement
|
|
|
|
To toggle between breaking and not breaking
in
|
Alt + F8
|
class modules and then continue execution
|
|
To select all visible code in the Module
window
|
Ctrl + A
|
To halt the execution of code or a macro
|
Ctrl + Break
|
To move to the current field in the last
record, in
|
Ctrl + Down Arrow
|
|
|
Navigation mode
|
|
To display the next procedure
|
Ctrl + Down Arrow
|
To move to the last field in the last
record, in
|
Ctrl + End
|
Navigation mode
|
|
|
|
To open the selected table, query, form,
report,
|
Ctrl + Enter or Alt + D
|
macro, or module in Design view
|
|
To toggle between a custom menu bar and a
built-in Ctrl + F11
|
|
menu bar
|
|
To invoke a Builder
|
Ctrl + F2
|
|
|
To put focus on the Procedure Box
|
Ctrl + 2 (then press Tab)
|
To find the next occurrence of selected text
|
Ctrl + F3
|
To run code to the current insertion point
and halt
|
Ctrl + F8
|
execution
|
|
To turn on Move mode (MOV appears in the
lower
|
Ctrl + F8
|
|
|
right corner of the window)
|
|
To set the next statement
|
Ctrl + F9
|
To display the Debug window
|
Ctrl + G
|
To move to the first field in the first
record, in
|
Ctrl + Home
|
|
|
Navigation mode
|
|
To display quick information
|
Ctrl + I
|
To list properties and methods
|
Ctrl + J
|
To display the Calls dialog box
|
Ctrl + L
|
|
|
To move to the current field in the next
record
|
Ctrl + Page Down
|
To go right one screen
|
Ctrl + Page Down
|
To move to the current field in the previous
record
|
Ctrl + Page Up
|
To go left one screen
|
Ctrl + Page Up
|
|
|
To select a form or report
|
Ctrl + R
|
To return to the last line position in the
previously
|
Ctrl + Shift + F2
|
viewed procedure
|
|
To step out of a procedure
|
Ctrl + Shift + F8
|
|
|
To clear all breakpoints
|
Ctrl + Shift +F9
|
To display parameter information
|
Ctrl + Shift + I
|
To list constants
|
Ctrl + Shift + J
|
To exit the subform and move to the previous
field
|
Ctrl + Shift + Tab
|
in the main form or previous record
|
|
|
|
To complete the Visual Basic keyword
|
Ctrl + Spacebar
|
To cycle through the tab of each object's
type
|
Ctrl + Tab
|
To exit the subform and move to the next
field in the Ctrl + Tab
|
|
master form or next record
|
|
|
|
To move to the current field in the first
record, in
|
Ctrl + Up Arrow
|
Navigation mode
|
|
To display the previous procedure
|
Ctrl + Up Arrow
|
To cut the current line and copy it to the
Clipboard
|
Ctrl + Y
|
To enter the selected item in a list
|
Ctrl + Enter or Tab
|
|
|
To move down one line
|
Down Arrow
|
To move to the current field in the next
record
|
Down Arrow
|
To move to the last object
|
End
|
To move to the last field in the current
record, in
|
End
|
Navigation mode
|
|
|
|
To move to the last field in the current
record, in
|
End
|
Navigation mode
|
|
To open the selected report in Print Preview
|
Enter
|
To open the selected table or query in
Datasheet
|
Enter
|
|
|
view, or form in Form view
|
|
To run the selected macro
|
Enter
|
To enter the selected item and move the
cursor to
|
Enter
|
the next line
|
|
To make the list disappear
|
Esc
|
|
|
To turn off Move mode
|
Esc
|
To display context-sensitive Help about the
keyword F1
|
|
containing the insertion point
|
|
To bring the Database window to the front
|
F11 or Alt + F1
|
|
|
To rename a selected object
|
F2
|
Switch between edit mode (with insertion
point
|
F2
|
displayed) and navigation mode
|
|
To display the complete hyperlink address
for a
|
F2
|
selected hyperlink
|
|
|
|
|
|
|
|
|
|
|
|
To display the Object Browser
|
F2
|
To find the next occurrence of the text
specified in
|
F3
|
the Find or Replace dialog box when the
dialog box
|
|
|
|
is closed
|
|
To switch to Form view from form design or a
form
|
F5
|
module
|
|
To move to the record number box;
|
F5 then type the record
|
|
number and press Enter
|
|
|
To move to the record number box;
|
F5 then type the record
|
|
number and press Enter
|
To continue execution of code or macro
|
F5
|
To run a parameterless subprocedure
containing
|
F5
|
the insertion point, from the Module window
|
|
|
|
To switch between the upper and lower
portions of
|
F6
|
a window (Design view of tables, macros, and
|
|
queries and the Advanced Filter/Sort window
only)
|
|
To switch between the upper and lower panes
|
F6
|
|
|
To cycle forward through sections
|
F6
|
To check spelling
|
F7
|
To step into a procedure (single step)
|
F8
|
To toggle a breakpoint at the selected line
|
F9
|
|
|
To move to the first object
|
Home
|
To move to the first field in the current
record, in
|
Home
|
Navigation mode
|
|
To move to the first field in the current
record, in
|
Home
|
Navigation mode
|
|
|
|
To move the selected column to the left one
column Left Arrow
|
|
in Move mode
|
|
To move down one window
|
Page Down
|
To go down one page; at the end of the
record,
|
Page Down
|
moves to the equivalent page on the next
record
|
|
|
|
To go down one screen
|
Page Down
|
To move up one window
|
Page Up
|
To go up one page; at the end of the record,
moves Page Up
|
|
to the equivalent page on the previous
record
|
|
To go up one screen
|
Page Up
|
|
|
Press Navigating and opening objects Press
|
Right Arrow
|
Navigate between fields and records Press To
|
|
move columns
|
|
To move the selected column to the right one
|
Shift + Ctrl + Tab
|
|
|
column in Move mode
|
|
To cycle through the tab of each object's
type right
|
Shift + Enter
|
to left
|
|
To view a procedure definition, variable, or
keyword Shift + F2
|
|
To find the previous occurrence of the text
specified Shift + F3
|
|
in the Find or Replace dialog box when the
dialog
|
|
box is closed
|
|
|
|
To reset execution of code or macro
|
Shift + F5
|
To cycle back through sections
|
Shift + F6
|
To step over a procedure
|
Shift + F8
|
To create an instant watch for a selected
|
Shift + F9
|
expression
|
|
|
|
To move to the previous field
|
Shift + Tab
|
To enter the subform from the following
field in the
|
Shift + Tab
|
main form
|
|
To remove indentation from selected lines
|
Shift + Tab or Ctrl + Shift
|
|
|
|
+ M
|
To move to the previous field
|
Shift + Tab, or Left Arrow
|
To move to the next field
|
Tab
|
To enter the subform from the preceding
field in the Tab
|
|
main form
|
|
To indent selected lines
|
Tab or Ctrl + M
|
To move to the next field
|
Tab, Enter, or Right
|
|
Arrow
|
To move up one line
|
Up Arrow
|
To move to the current field in the previous
record
|
Up Arrow
|
Leave a Comment