field data types

The following table lists the Field data types.

DAO Field data type Constant
Big Integer dbBigInt
Binary dbBinary
Boolean dbBoolean
Byte dbByte
Char dbChar
Currency dbCurrency
Date/Time dbDate
Decimal dbDecimal
Double dbDouble
Float dbFloat
GUID dbGUID
Integer dbInteger
Long dbLong
Long Binary (OLE Object) dbLongBinary
Memo dbMemo
Numeric dbNumeric
Single dbSingle
Text dbText
Time dbTime
TimeStamp dbTimeStamp
VarBinary dbVarBinary