Options of this group allow you to set colors for basic grid elements. Use the ellipsis button to open the Color dialog allowing you to select the required color from the palette.
Defines the background color of the data grid.
Defines the color of the selected row in the data grid.
Defines the color of the odd rows (applied if the Stripy grids option is set).
Defines the format for displaying SMALLINT, NUMERIC, INTEGER and BIGINT fields.
Defines the format for displaying FLOAT, DOUBLE and DECIMAL fields.
Defines the format for displaying DATETIME fields.
Defines the format for displaying DATE fields.
Defines the format for displaying TIME and TIMESTAMP fields.
Defines the text that stands for NULL values in grid.
Defines the font color for displaying NULL values in the grid. Use the ellipsis button to open the Color dialog allowing you to select the required color from the palette.
Displays the odd grid rows in the colors specified by the Stripy option.
Use Ctrl+Up to increase spin values
Allows you to use the Ctrl+Up and the Ctrl+Down key combinations for editing the spin values (numeric field values).
Show editor immediately
Checking this option allows you to edit the cell value immediately after you click the cell.
Enable auto-search in grid
If this option is checked, the cursor is automatically forwarded to the closest match when you start typing.
With this option set, multiple rows can be selected in grid.
Load all rows mode
With this option off, the grid loads only a fixed number of data records into the memory. This option minimizes dataset loading time. Automatic sorting, filtering, summary calculations are not supported in this mode.
With this option on, the grid loads all records from the returned dataset. This option increases the grid performance by reloading only the modified data records during the update process. In this mode all features (automatic sorting, filtering and summary calculations) are available.
Query fetch all records
With this option set, all records are fetched upon a query execution.
Show text fields as string
If this option is checked, the text fields are viewed as ordinary strings. Otherwise they are displayed as BLOB fields.
Max fields width (chars)
Defines the maximum width of CHAR and VARCHAR fields displayed in the grid.
Min fields width (chars)
Defines the minimum width of CHAR and VARCHAR fields displayed in the grid.
Grid layout preferences
Save and restore layout
Select the option to keep the original grid width.
Autofit column width
Select option to shrink the grid columns so that the longest visible value fits the column width.