Shortcuts Grouped by Key Combinations

These tables list all keyboard shortcuts by common combinations of keys.

Combinations involving Function keys

Note: Where the key combination is different in the web client, that combination is given in parentheses ( ). Where there is no equivalent key combination in the web client, it is indicated by (n/a). Otherwise, the key combination is the same in both the Windows client and the web client.
Keys Action Description
F1 Get help with the current field or form. Brings up the online help in a separate window.
  • If the focus is on an active field, this opens the help for the current field.
  • If the focus is not on an active field, this opens the help for the form.
F2 Displays the list for a drop-down list This is functionally the same as clicking the down arrow on a drop-down list component.
Ctrl+F2

(n/a)

 Repeats a Find operation. Locates the next entry in the field that matches the specified criteria without having to re-enter the criteria.
F4 Begins or executes a Filter-in-Place search. If a form is displaying a collection, cancels the current filter-in-place and clears the form so you can perform a new search.

If the form has already been cleared, performs a Filter-in-Place search based on any values you entered into one or more fields. If you left all fields blank, the search retrieves all available records up to the cap.

See Finding Records with Filter-in-Place.

Ctrl+F4 Closes the current form window. If changes have been made to any records, or if any records have been marked for deletion, the system asks whether you want to save the changes before closing the form window.
F5

(Ctrl+F5)

Refreshes the entire collection;

OR

Clears the filter criteria.

If a collection is being displayed and you have made changes to any records, or if you have marked any records for deletion, the system asks whether you want to save the changes before refreshing the collection. If you answer Yes, the changes are saved and deletions are made permanent. If you answer No, all values on the form revert to their original values.

If no collection is being displayed, clears any filter criteria that have been entered into the fields.

Ctrl+F5

(n/a)

 Refreshes a single record. Reverts the selected record to its original value and removes any change or deletion indicators. No prompt is given.

Use this to effectively undo a change or "undelete" a record marked for deletion.

F6

(n/a)

 Shifts the focus on the form. Works with multiview forms only.

If the focus is on the grid side, shifts the focus to the detail side. If the focus is on the detail side, shifts the focus to the grid side.

Ctrl+F6

(n/a)

 Switches between open forms. "Cycles through" the open forms, moving the focus from one to the next.
F7 Moves to the previous record. Works only when a record is selected in a collection. Moves the focus to the previous record in the collection.
F8 Moves to next record. Works only when a record is selected in a collection. Moves the focus to the next record in the collection.
Ctrl+F8

(n/a)

 Moves to the next collection. In forms that display multiple collections, moves the focus to the next collection.

Combinations involving the Control (Ctrl) key

Keys Action Description
Ctrl+1

(Shift+Ctrl+1)

Toggles detail-only view on/off. Works only with multiview forms, query forms, or other forms in which there are split views.

If both views (split view) or only the grid view is displayed, this keypress combination displays only the detail view.

If only the detail view is displayed, this keypress combination displays the split view.

Ctrl+2

(Shift+Ctrl+2)

Toggles grid-only view on/off. Works only with multiview forms, query forms, or other forms in which there are split views.

If both views (split view) or only the detail view is displayed, this keypress combination displays only the grid view.

If only the grid view is displayed, this keypress combination displays the split view.

Ctrl+F2

(n/a)

 Repeats a Find operation. Locates the next entry in the field that matches the specified criteria without having to re-enter the criteria.
Ctrl+F4 Closes the current form window. If changes have been made to any records, or if any records have been marked for deletion, the system asks whether you want to save the changes before closing the form window.
Ctrl+F5

(n/a)

 Refreshes a single record. Reverts the selected record to its original value and removes any change or deletion indicators.

Use this to effectively undo a change or "undelete" a record.

Ctrl+F6

(n/a)

 Switches between open forms. "Cycles through" the open forms, moving the focus from one to the next.
Ctrl+F8

(n/a)

 Moves to the next collection. In forms that display multiple collections, moves the focus to the next collection.
Ctrl+A Adds a new value to a field. (Not applicable in the web client.) In grid collections, selects all records in the collection currently displayed.

(In both clients) In drop-down components only, allows you to create a new value for a drop-down field, and then have that new value returned to the field.

See Adding a New Field Value.

Ctrl+C

OR

Ctrl+Insert (Alternative for grid cells)

Copies text from a field or contents of a grid cell. As is common in most Windows programs, copies any selected text to the system clipboard. This allows you to paste the copied text somewhere else.
Note:  If you are copying groups of cells within a grid and the last-selected cell is an editable field, the Ctrl+C keyboard shortcut does not work. Instead, you must use the Ctrl+Insert key combination to copy the selected cells to the system clipboard.
Ctrl+D Marks a record for deletion. Works only in collections. The record is not actually deleted until you do a save operation.
Ctrl+E

(n/a)

 Toggles Design Mode on/off. Available only if you have the correct editing permissions.

Use this key combination to enter or exit Design Mode for the active form.

Ctrl+F

(n/a)

 Initiates a search for a specific value for a field. Works in drop-down lists only.

See Finding a Specific Value in a Drop-down List.

Ctrl+G

(n/a)

 Regenerates the form. Used in Design Mode only.
Ctrl+L

(n/a)

 Finds details for a value in a drop-down field. When you use this key combination, the system opens the associated form. To see an abbreviated summary of the list value, without having to open the associated form, press F2.

See Finding Details about a Value in a Drop-down List.

Ctrl+N

(n/a)

 Creates a record. Works only in collections. Inserts a new, blank record below whichever record is currently selected.
Ctrl+O Opens a form. Opens the Select Form dialog box, which you can use to locate and select the form you want to open.

See Finding and Opening Forms Using the Select Form Dialog Box.

Ctrl+P

(n/a)

 Prints a record or collection of records. See Printing Records or Collections of Records.
Ctrl+Q

(n/a)

 Allows you to search for records using Filter By Query. (Available only from multiview forms.) Opens the query form associated with the multiview form.

See Finding Records Using a Query Form.

Ctrl+S Saves a form. Saves any changes, but does not close the form.

Any records that have been modified or marked for deletion are permanently modified or deleted when this shortcut is used.

Ctrl+U

(n/a)

 Unloads all global form objects. Used in Design Mode only.
Ctrl+V Pastes text into a field. As is common in most Windows programs, pastes the contents of the system clipboard into the field where the cursor is.

You can use this option only in fields that allow you to enter text.

Ctrl+X Cuts text from a field. As is common in most Windows programs, removes selected text from a field, but keeps a copy of it on the system clipboard. This allows you to paste the deleted text somewhere else.
Ctrl+Z Undoes an editing operation. Works only for editing operations (cut/copy/paste). There is no multiple undo, and you can only undo the operation while you are still in the field where you performed it. Once you move out of the field, this shortcut no longer works. To undo changes made after you move out of the field, use Ctrl+F5.
Ctrl+Home Moves the cursor to the beginning of a record. Wherever the focus is, this keypress combination moves the focus to the first editable field for a record. On a grid component, this moves the focus to the first active field (column).
Ctrl+Tab

(n/a)

 Switches between open forms. "Cycles through" the open forms, moving the focus from one to the next.

Miscellaneous other key combinations

Keys Action Description
Up Arrow Moves to the previous record.
  • With focus in a collection and a record selected, moves the focus to the previous record in the collection.
  • In a drop-down list, when you tab into the list field, or with the list showing, selects the previous item in the list.
  • In a date field, with the calendar drop-down showing, regresses the date by one week.
  • In a text field, behaves like the Left Arrow key.
Down Arrow Moves to next record.
  • With focus in a collection and a record selected, moves the focus to the next record in the collection.
  • In a drop-down list, when you tab into the list field, or with the list showing, selects the next item in the list.
  • In a date field, with the calendar drop-down showing, advances the date by one week.
  • In a text field, behaves like the Right Arrow key.
Left Arrow Moves to previous field or character.
  • In a grid, moves the focus to the previous field in the record.
  • In a date field, with the calendar drop-down showing, regresses the date by one day.
  • In a text or other input field, moves the cursor to the left one character position.
Right Arrow Moves to next field or character.
  • In a grid, moves the focus to the next field in the record.
  • In a date field, with the calendar drop-down showing, advances the date by one day.
  • In a text or other input field, moves the cursor to the right one character position.
Delete (DEL) Marks selected text or a record for deletion.

  • In fields, deletes the selected text. Works only for fields in which you can make changes and select input.

    The text is not permanently deleted until you save the form. So, if you need to undo the deletion before saving the form, you can return the field to its original value by pressing Ctrl+F5.

  • In collections, marks the selected record for deletion. The record is not actually deleted until you do a save operation.
  • In Design Mode, deletes the selected component.
Home Moves the cursor to the beginning of a field or record.
  • In an editable field, moves the cursor to the beginning of a field. In a display-only field, moves the cursor to the first column in the grid.
  • In conjunction with the Ctrl key (Ctrl+Home), if in a grid, moves the cursor to the first active column in the record (in which you can make a change). In a detail view or other type of form, moves the cursor (and the focus) to the first editable field in the form.
Page Down

(n/a)

 Advances the records displayed by one set. Works only in grids.

If all available records fit in one view, moves to the last record.

Page Up

(n/a)

 Regresses the records displayed by one set. Works only in grids.

If all available records fit in one view, moves to the first record.