ColDataType Property

Returns or sets the data type for the column.

Syntax

[form!]VSFlexGrid.ColDataType(Col As Long)[ = DataTypeSettings ]

Remarks

Valid settings for the ColDataType property are listed below:

 

Constant

Value

FlexDTEmpty

0

FlexDTNull

1

FlexDTShort

2

FlexDTLong

3

FlexDTSingle

4

FlexDTDouble

5

FlexDTCurrency

6

FlexDTDate

7

FlexDTString

8

FlexDTDispatch

9

FlexDTError

10

FlexDTBoolean

11

FlexDTVariant

12

FlexDTUnknown

13

FlexDTDecimal

14

flexDTLong8

20

FlexDTStringC

30

FlexDTStringW

31

 

This property is automatically set for each column when the control is bound to a recordset, so you can determine the data type of each field. When not in bound mode, you may set this property using code.

There are two column types that receive special treatment from the control:

FlexDTDate

This setting is taken into account when sorting dates either using the Sort property or when the user clicks the ExplorerBar. If you don't set the column type to flexDTDate, the dates will be sorted as strings.

FlexDTBoolean

This setting causes the control to display check boxes instead of strings. The mapping between strings and check boxes follows the rules for Variant conversion: any non-zero value and the "True" string are displayed as checked boxes; zero values are displayed as unchecked boxes.

For example:

    fg.ColDataType(1) = flexDTBoolean

    fg.TextMatrix(1, 1) = 1         ' checked

    fg.TextMatrix(2, 1) = True      ' checked

    fg.TextMatrix(3, 1) = "True"    ' checked

    fg.TextMatrix(4, 1) = 0         ' not checked

    fg.TextMatrix(5, 1) = "False"   ' not checked

If you want to display custom strings for Boolean values instead of check boxes, set the ColFormat property to a string containing the values you want to display for True and False values, separated by a semicolon. For example:

    fg.ColDataType(2) = flexDTBoolean

    fg.ColFormat(2) = "Yes;Not Available" ' or "True;False", "On;Off", "Yes;No", and so on

When setting this property, the Col parameter should be set to a value between zero and Cols - 1 to set the data type of a given column, or to -1 to set the data type of all columns.

Data Type

DataTypeSettings (Enumeration)

See Also

VSFlexGrid Control