All Constants Color Constants Comparison Constants Date Format Constants Date and Time Constants Drive Object FileAttribute Property File Input/Output Constants MsgBox Constants String Constants Tristate Constants CONSTANTS:  VarType VarType Constants   You may use either the CONSTANT (left column) or the VALUE (center column) in your code and get the same results.   CONSTANT VALUE DESCRIPTION VBEmpty 0 Uninitialized VBNull 1 Contains no valid data VBInteger 2 Integer subtype VBLong 3 Long subtype VBSingle 4 Single subtype VBDouble 5 Double subtype VBCurrency 6 Currency subtype VBDate 7 Date subtype VBString 8 String subtype VBObject 9 Object VBError 10 Error subtype VBBoolean 11 Boolean subtype VBVariant 12 Variant (only use for arrays of variants) VBDataObject 13 Data access object VBDecimal 14 Decimal subtype VBByte 17 Byte subtype VBArray 8192 Array Copyright 1999-2004 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information