VarType Function

Returns an Integer indicating the type or subtype of a variable.

Syntax

VarType(varname)

The required varname argument is any variable.

Return Values

Constant Value Description
cdbEmpty 0 Empty (uninitialized). Returns for Variant only.
cdbNull 1 Null
cdbInteger 2 Integer
cdbLong 3 Long integer
cdbSingle 4 Single-precision floating-point number
cdbDouble 5 Double-precision floating-point number
cdbDate 7 Date value
cdbString 8 String
cdbObject 9 Object
cdbBoolean 11 Boolean value
cdbByte 17 Byte value

    Note: These constants are specified by ConceptDraw Basic. The names can be used anywhere in your code in place of the actual values.

Example

Dim IntVar, StrVar, DateVar, MyCheck
' Initialize variables.
IntVar = CInt(459)
StrVar = "Hello World"
DateVar = #2/12/69# 

MyCheck = VarType(IntVar)   ' Returns 2.
Trace MyCheck

MyCheck = VarType(DateVar)   ' Returns 7.
Trace MyCheck

MyCheck = VarType(StrVar)   ' Returns 8.
Trace MyCheck

 

See Also

Data Type Summary , IsDate Function , IsEmpty Function , IsNull Function , IsNumeric Function