Record RecordType Property Parameter Type Property Property Type Property Stream Type Property PROPERTY: Field::Type DataTypeEnum = fieldobject.Type fieldobject.Type = DataTypeEnum   The Type property sets or returns a DataTypeEnum value which is the data type or operational type of the Field object. This property becomes read/write after the value has been set and the object has been added to the Fields Collection. Otherwise it is read-only.   Unfortunately, some providers may not support all of the possible data types. If a provider encounters a data type that it does not recognize, it will usually change it to a data type that it does recognize.   DataTypeEnum Constants   Constant Value Description adArray 0x2000 Combine with another data type to indicate that the other data type is an array adBigInt 20 8-byte signed integer adBinary 128 Binary adBoolean 11 True or false Boolean adBSTR 8 Null-terminated character string adChapter 136 4-byte chapter value for a child recordset adChar 129 String adCurrency 6 Currency format adDate 7 Number of days since 12/30/1899 adDBDate 133 YYYYMMDD date format adDBFileTime 137 Database file time adDBTime 134 HHMMSS time format adDBTimeStamp 135 YYYYMMDDHHMMSS date/time format adDecimal 14 Number with fixed precision and scale adDouble 5 Double precision floating-point adEmpty 0 no value adError 10 32-bit error code adFileTime 64 Number of 100-nanosecond intervals since 1/1/1601 adGUID 72 Globally Unique identifier adIDispatch 9 Currently not supported by ADO adInteger 3 4-byte signed integer adIUnknown 13 Currently not supported by ADO adLongVarBinary 205 Long binary value adLongVarChar 201 Long string value adLongVarWChar 203 Long Null-terminates string value adNumeric 131 Number with fixed precision and scale adPropVariant 138 PROPVARIANT automation adSingle 4 Single-precision floating-point value adSmallInt 2 2-byte signed integer adTinyInt 16 1-byte signed integer adUnsignedBigInt 21 8-byte unsigned integer adUnsignedInt 19 4-byte unsigned integer adUnsignedSmallInt 18 2-byte unsigned integer adUnsignedTinyInt 17 1-byte unsigned integer adUserDefined 132 User-defined variable adVarBinary 204 Binary value adVarChar 200 String adVariant 12 Automation variant adVarNumeric 139 Variable width exact numeric with signed scale adVarWChar 202 Null-terminated Unicode character string adWChar 130 Null-terminated Unicode character string   Code (VBScript): For Each objField In rsData.Fields    If objField.Type = adIUnknown Then       Response.Write "WARNING: Type is Unknown for " & objField.Name & "<br>"    End If Next Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information