Key

Action

Up/Down Arrows
 

These keys move the current cell to adjacent rows.

Left/Right Arrows
 

If the property AllowArrows is True (the default), these keys move the current cell to adjacent columns. If the AllowArrows property is False, then these keys move focus from control to control and cannot be used to move between cells.

ENTER
 

By default, the ENTERkey behaves in the same manner as the RIGHT ARROW key, by moving the current cell from left to right along the adjacent columns. The behavior for the ENTER key can be modified by using the DirectionAfterEnter property, click icon to change the direction.. When editing a cell, the ENTER key will save edits and then move to the next cell.

TAB
 

If the TabAction property is set to Control Navigation (the default), the TAB key moves focus to the next control on the form as determined by the tab order. If the TabAction property is set to ColumnNavigation or GridNavigation, the TAB key moves the current cell to the next column, while SHIFT+TAB moves to the previous column. The differences between column and grid navigation are discussed in the next section.

PAGE UP, PAGE DOWN
 

These keys scroll the grid up or down an entire page at a time. Unlike the vertical scroll bar, thePAgE Up and PAgE DOWn keys change the current row by the number of visible rows in the grid's display. When paging up, the current row becomes the first row in the display area. When paging down, the current row becomes the last row in the display area, including the AddNew row. The current column does not change.

HOME, END
 

These keys move the current cell to the first or last column. If necessary, the grid will scroll horizontally so that the current cell becomes visible. The current row does not change. If the current cell is being edited, HOME and END move the insertion point to the beginning or end of the cell's text.

ALT + LEFT ARROW
 

Collapses all open child grids, if any.

ALT+RIGHT ARROW
 

Expands a child grid, if any.

DELETE
 

The DELETE button deletes the selected row(s). In edit mode, the DELETE key deletes the selected contents of a cell, deleting content to the right of the cursor.

SPACE BAR
 

The SPACE BAR key initiates button clicks and check box and radio button selection and de-selection.

BACKSPACE, CTRL+H
 

In Edit mode you can use the BACKSPACE key or the CTRL+H key combination to delete content from a cell, deleting content to the left of the cursor.

TAB
 

The TAB key ends cell editing mode, saving any content changes and leaving the current cell selected.

INSERT
 

In cell editing mode, the INSERT key changes the way text is entered in a cell. When the INSERT key is active, inputted text overwrites existing content.

CTRL+UP/DOWN ARROW
 

These key combinations allow you to navigate in a list box. The CTRL+UP ARROW key combination allows you to navigate up to the previous item in a list box. The CTRL+DOWN ARROW lets you navigate down to the next item

F1
 

View User's Manual

Cntrl+F1
 

Setup for customizing or adding application modules. Available only on build 598 and above

F2

Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet. When working in a form or report, press ESC to leave Navigation mode.

F4

This key shows or hides a combo box.

F5

Refresh dataset and reset layout

F9

Recalculate column formula

F10

View Central Menu

Cntrl+Home
 

Goto first record

Cntrl+End
 

Goto last record

Cntrl+Plus
 

Add new record at the bottom. Use the keyboard Numpad Plus sign

Cntrl+Minus

Delete current row. Use the keyboard Numpad Minus sign

Cntrl+S
 

Save or persist changes to the database

Cntrl+C
 

Copy. This key combination copies the selected content to the Clipboard

Cntrl+Shift+C
 

Copy with column header

Cntrl+X

Cut. This key combination cuts the selected content and copies it to the Clipboard

Cntrl+V

Paste. This key combination pastes the contents of the Clipboard to the selected location.

Copy/Paste To/Trom Excel is supported.

Cntrl+Shift+V

Paste with column header

Cntrl+F
 

Find and Replace

Cntrl+O
 

Open current cell link, if any

Cntrl+Z

Undo cell changes. To undo all changes click the icon.

Cntrl+Shift+L

Show/hide filter bar

Cntrl+ ) 0

Hide currect column. ") 0" is found after number 9 on the keyboard

Cntrl+Shift+ ) 0

Unhide Column

Cntrl+ ( 9

Hide current row. "( 9" is found after number 8 on the keyboard

Cntrl+Shift+ ( 9

Unhide Row

Alt+ Oemplus

Sum selected cells. Oemplus is similar to "+=" found after numbers 8, 9, 0, - on the keyboard

Cntrl+A

Select all cells within the grid. If followed by ENTER key, it will copy selected cells to the clipboard

Cntrl+Shift+Left

Select cells from current cell to the leftmost cell within the grid's selected row(s). If followed by ENTER key, it will copy selected cells to the clipboard

Cntrl+Shift+Right

Select cells from current cell to the rightmost cell within the grid's selected row(s). If followed by ENTER key, it will copy selected cells to the clipboard

Cntrl+Shift+Down

Select cells from current cell to the last row within the grid's selected columns. If followed by ENTER key, it will copy selected cells to the clipboard

Cntrl+Shift+Up

Select cells from current cell to the first row within the grid's selected columns. If followed by ENTER key, it will copy selected cells to the clipboard