Data Tab (Grid Properties Dialog Box)

Use this tab to set the properties of the columns in the Grid design-time control.

Options

Recordset

Select to specify which data source to use to fill the grid columns.

Available fields

Displays the available fields for the selected data source. Select the check box next to the field to add the field to the Grid columns list for output.

Add unbound column

Inserts a new row in Grid columns list. The Field/Expression and Header properties are set using the Edit columns area.

Grid columns

Displays the columns that are selected to output for this grid. The columns are displayed in the order listed. To add and remove columns from this list use the Insert Row and Delete Row buttons.

The Field/Expression and Header settings can be adjusted by clicking on the row to be edited and changing the options in the Edit row area.

Sort order, indicated by the up and down arrows

Moves the selected row in the column list up or down in the order to be listed. A row must be selected in the column list for these buttons to work.

Edit columns

Field/expression

Select to specify which field or expression should be used for the column selected in the column list. The column can display just the field data or an expression can be used to format the data. For example FormatCurrency can be used to format a numeric field using VBScript.

Header

Select to specify what to display in the header for the column selected in the column list.