Returns and sets a value that determines whether the row in the current band can be expanded and collapsed. The current band is defined by the Col and Row properties. This is a read-only property at run time and is not available at design time.
Syntax
object.BandExpandable(number) [=Boolean]
The BandExpandable property syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| number | A Long value indicating the number of the band in the MSHFlexGrid. |
| Boolean | A Boolean expression that determines whether a specific band can be expanded and collapsed. |
Settings
The settings for Boolean are:
| Setting | Description |
| True | Default. The band specified can be expanded and collapsed. |
| False | The band specified cannot be expanded and collapsed. |
Remarks
When a band is expandable, a standard plus (+) and minus (–) bitmap displays on the left of the first column within the band. This bitmap can be overridden by setting the ExpandPicture and CollapsePicture properties. When the grid first displays, all of the bands are collapsible by default.
Setting this property disables the user's capacity to expand or collapse the band; it doesn’t cause the rows within the specified band to expand or collapse. For example, if the child rows are shown before setting this property to False, the child rows continue to be shown after the setting.
For a band to be expandable, it must have at least one sub-band. Without a sub-band, the BandExpandable property is ignored.