Syntax
object.Cols(BandNumber) [= value]
object.Rows [= value]
Syntax for the Cols and Rows properties has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| BandNumber | Optional. A Long value that either specifies the band to get or sets the total number of columns. |
| value | A Long value that specifies the number of columns or rows. |
Remarks
You can use these properties to expand and shrink ModHFGrid dynamically at run time.
The minimum number of rows and columns is zero. The maximum number is limited by the memory available on your computer.
The value of Cols must be at least one greater than the value of FixedCols, unless they are both set to zero. The value of Rows must be at least one greater than the value of FixedRows, unless they are both set to zero.
When number is not specified, it defaults to zero. Hence, when the ModHFGrid is not bound to a hierarchical Recordset, using zero or not specifying number both have the same result.