Help Center

BandDisplayproperty

Specifies how the bands display within the MSHFlexGrid.

Windowspropertydoc-orphan
No implementation located. This member is documented, but the source scan found no matching declaration. It is likely declared in a header this scan does not resolve, or provided by a macro.

Syntax

PROPERTY BandDisplay () AS BandDisplaySettings
PROPERTY BandDisplay (BYVAL settings AS BandDisplaySettings)

Parameters

NameDescription
settingsA value that specifies how the bands display within the grid:
flexBandDisplayHorizontal: Default. The bands within the grid display horizontally (across).
flexBandDisplayVertical: The bands within the grid display vertically (up and down).

Description

Specifies how the bands display within the MSHFlexGrid.

Remarks

This property is only effective when the MSHFlexGrid is bound to a hierarchical data source, such as an ADO Shaped Recordset. It has no effect on a standard flat (non-hierarchical) grid.

Switching to vertical display is often used for "pivoted" data views where relationships are easier to read from left-to-right rather than top-to-bottom.

Regardless of the display orientation, you can still control the appearance of headers for each level using properties like BackColorHeader or GridLinesHeader.

Example

' Changes the bands to display vertically (columns) grid.BandDisplay = flexBandDisplayVertical

Reference