You can use the standard Windows editing keys when working in the SQL pane. For example, you can use Ctrl+ Arrow keys to move between words, and the Cut, Copy, and Paste commands on the Home tab work as they normally do.
|
Advertisement
Note: In Datasheet view, Extended Selection appears in the lower-right corner of the window
|
Note: If the insertion point is not visible, press F2 to display it.
|
Note: If additional views are available, successive keystrokes move the focus to the next available view.
|
|||
Note: Ctrl+Period (.) does not work under all conditions with all objects.
|
|
Move back to the previous Help topic (Back button) |
||
or
|
|||
|
Delete the selection or the character to the left of the insertion point |
||
|
Move forward to the next Help topic (Forward button) |
||
|
Go back to Access Help Home |
||
|
Refresh the window (Refresh button) |
||
|
Stop the last action (Stop button) |
||
|
Cancel the command and close the dialog box |
||
|
Close the selected drop-down list box |
||
|
Undo changes in the current field or current record (if both the current field and current record have been changed, press Esc twice to undo changes, first in the current field and then in the current record) |
||
|
Cancel Extend mode |
||
|
Exit Navigation mode in a form or report |
||
|
Switch between selecting the current record and the first field of the current record, in Navigation mode |
||
|
Move the insertion point to the end of the field, in single-line fields; or move it to the end of the line in multi-line fields |
||
|
Move to the end of a line |
||
|
Move to the last field in the current record |
||
|
Move to the beginning of a line |
||
|
Move the insertion point to the beginning of the field, in single-line fields; or move it to the beginning of the line in multi-line fields |
||
|
Move to the first field in the current record |
||
|
Toggle the focus between sections (header, body, footer) of the wizard |
||
|
Switch between the upper and lower portions of a window (Design view of queries, macros, and the Advanced Filter/Sort window) |
||
|
Cycle through the field grid, property sheet, field properties, the Navigation Pane, Quick Access Toolbar, and KeyTips on the ribbon (Design view of tables) |
||
|
Switch among areas in the Help window, such as the toolbar and the Search list |
||
|
Print the current Help topic (if the cursor is not in the current Help topic, press F6, and then press Ctrl+P) |
||
|
Add a new record |
||
|
In a datasheet, delete the current record |
||
|
Copy the selection to the Clipboard |
||
|
Cut the selection and copy it to the Clipboard |
||
|
Delete the selection or the character to the right of the insertion point |
||
|
Paste the contents of the Clipboard at the insertion point |
||
|
Undo typing |
||
|
Go to the Navigation PaneSearch box (if the focus is already on the Navigation Pane) |
||
|
Open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only) |
||
|
Move up one paragraph |
||
|
Move to the current field in the first record |
||
|
Move to the current field in the last record |
||
|
Move down one paragraph |
||
Advertisement |
|||
|
Display the full set of commands on the task pane menu |
||
|
Open the selected drop-down list box |
||
|
Move the insertion point to the beginning of the field, in multi-line fields |
||
|
Move to the beginning of a text box |
||
|
Move to the end of a text box |
||
|
Move the insertion point to the end of the field, in multi-line fields |
||
|
Move to the last field in the last record |
||
|
Insert a tab in a cell |
||
|
Open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only) |
||
|
Find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only) |
||
|
Repeat the last Find action |
||
|
Move one character to the right |
||
|
Move to the next field |
||
|
Move the insertion point one character to the right |
||
|
Move the insertion point one character to the left |
||
|
Move to the previous field |
||
|
Move one character to the left |
||
|
Open the Choose Builder dialog box from a selected control on a form or report (Design view only) |
||
|
Open the Visual Basic Editor from a selected property in the property sheet for a form or report |
||
|
Check spelling |
||
|
Switch between the values in a check box or option button |
||
|
Move to the next row |
||
|
Move down one line |
||
|
Move to the current field in the next record |
||
|
Move to the current field in the previous record |
||
|
Move up one line |
||
|
Move to the preceding row |
||
|
Move one word to the left |
||
|
Toggle backward between views when in a table, query, form, or report |
||
|
Move the insertion point one word to the left |
||
|
Move the insertion point one word to the right |
||
|
Toggle forward between views when in a table, query, form, or report |
||
|
Move one word to the right |
||
|
Display the complete hyperlink address (URL) for a selected hyperlink |
||
|
Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet |
||
|
Move between the upper and lower panes of the Field List |
||
|
Select the next field |
||
|
Toggle the focus forward between controls in the wizard |
||
|
Select the next hidden text or hyperlink, including Show All or Hide All at the top of a topic |
||
|
Move to the next field |
||
|
Select the next item in the Help window |
||
|
(at the end of the last row) Add a new row at the bottom of the table |
||
|
Move to the next cell |
||
|
Start a new paragraph |
||
|
Perform the action for the selected item |
||
|
In the AccessHelp topics list, expand or collapse the selected item |
||
|
In a Table of Contents in tree view, expand or collapse the selected item |
||
|
Perform the action for the selected Show All, Hide All, hidden text, or hyperlink |
||
|
Perform the action assigned to the default button in the dialog box |
||
|
Add the selected field to the form or report detail section |
||
|
Open the Help window |
||
|
Exit Access |
||
|
Select the previous item in the Help window |
||
|
Move to the preceding cell |
||
|
Select the previous hidden text or hyperlink |
||
|
Move to the previous field |
||
|
Recalculate the fields in the window |
||
|
Refresh the contents of a Lookup field list box or combo box |
||
|
Complete the wizard |
||
|
Move to the next page of the wizard |
||
|
Turn on Extend mode (repeatedly pressing F8 extends the selection to the word, the field, the record, and all records) |
||
|
Change the size of the selection by one character to the left |
||
|
Change the size of the selection by one character to the right |
||
|
Extend the selection to the previous record, if the current record is selected |
||
|
Scroll larger amounts up or down, respectively within the currently displayed Help topic |
||
or
|
|||
|
Copy a screenshot of the entire screen to the Clipboard |
||
|
Copy the value from above row |
||
|
Delete all characters to the right of the insertion point |
||
|
Undo typing |
||
|
Invoke a Builder |
||
|
Toggle backward between views when in a table, query, form, or report |
||
|
Toggle forward between views when in a table, query, form, or report |
||
|
Requery the underlying tables; in a subform, this requeries the underlying table only for the subform |
||
|
Undo the previous extension |
||
|
Extend a selection to adjacent fields in the same row in Datasheet view |
||
|
Change the size of the selection by one word to the left |
||
|
Change the size of the selection by one word to the right |
||
|
Move up or down the Field List pane |
||
|
Extend a selection to adjacent rows in Datasheet view |
||
|
Scroll small amounts up or down within the currently displayed Help topic |
||
|
In a Table of Contents in tree view, select the previous or next item, respectively |
||
|
Show or hide the Field List pane |
||
|
Copy a screenshot of the current window to the Clipboard |
||
|
Switch from the Visual Basic Editor back to form or report Design view |
||
|
Insert the default value for a field |
||
|
Insert the value from the same field in the previous record |
||
|
Insert the current date |
||
|
Insert the current time |
||
|
er Open the list of choices and change the connection state |
What is your favorite Microsoft Access 2019 hotkey? Do you have any useful tips for it? Let other users know below.
1111393
500198
412256
369346
309189
279602
4 hours ago
4 hours ago
23 hours ago
23 hours ago Updated!
Yesterday Updated!
Yesterday
Latest articles