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