Result Grids

Many VimBiz forms allow searching in the database for information, and returning the result of the search in a grid format:

Column Sorting

Double-click on the Header or Title of a column to toggle the sorting between A-Z and Z-A for that column.

Column Size

Column size can be adjusted with the mouse by sliding the bar between the column title boxes.

Contextual Menu

Right-clicking in a grid will give the user a context menu where most performed actions are made available, such as the ability to export the grid data to HTML or Excel.

Editable Column Content

Certain column headers will contain a white gradient color:

This means the cells under these columns can be edited by the user by double-clicking.

Paging

For performance reasons, grid results are limited to 100 per page (paging) in many VimBiz forms.

Directional arrows allow the user to navigate through the results:

Number of Records Found

Hovering over a tab will display the total number of records found.

This number will also appear at the right of the directional arrows.

Column Display Options

Right-click on the grid header to define what columns are displayed and how they are stacked.

Customize which columns appear in the grid by checking them (to show) or unchecking them (to hide)

Customize whether columns are stacked or listed individually by and selecting Alternate Column Stacking.

Row Height

Click on any row with the mouse, then hold down the CTRL key.

Click the + key to make the row wider

Click the - key to make the row narrower.

Customize Column Fonts

Many forms offer an additional context menu, where users can further customize their grid.

Right-click on the desired column and select the Customize Grid option, that offers options to change the size and formatting of the font.