Previous Topic

Next Topic

Book Contents

Book Index

Form Designer List Grid Properties

Navigator > Setup > Form Designer > Layout tab > Component Editor > Properties tab

See also Form Designer Component Properties for properties common to different component types.

Right-click and select Open Table from the context menu, to open the Table Field Editor for the Table linked to the grid.

The following properties are available for List Grid Components:

ActiveRowColor

The colour to highlight the active row in the grid, if ActiveFocused is set to true. Click Open Color Dialog (F2) to select the colour.

AllowTotals

Set AllowTotals True to allow totals on the grid.

GridTotalled

If AllowTotals is True toggles Grid totalling on / off.

Hint

The Hint text to be displayed when the mouse hovers over the component.

ScrollBars

Set whether scroll bars are available on the component. Select from None, Horizontal, Vertical or Both.

TabOrder

Set the sequential tab order for components, when the Tab key is pressed in the form.

TabStop

When True, this component will be included in the tab order. When False, the Tab key will not stop at this component.

Table

Select a table to display in the grid.

Use the following Method to access Totals in List Grids

Method: GetTotalValue (Number)

Method that takes in a string of the field and returns the total value if the grid has been totalled.

gridListGrid1.GetTotalValue("ExclusiveAmountBs")

Returns null if the grid is not totalled or the field cannot be totalled (e.g. FX Mixed)

Can be tested with the IsNull() method.