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 |
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 |
TabStop |
When True, this component will be included in the tab order. When False, the |
Table |
Select a table to display in the grid. |
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.