Access™ 2007 VBA Programmer's Reference

D.3. DAO Field Types

The following table lists the constants in the DAO DataTypeEnum and their corresponding data types in the Access Table designer.

DAO DataTypeEnum	Constant Value	Access Field Type
dbAttachment	101	Attachment
dbBigInt	16	Cannot create in Access, but can be used by linked tables
dbBinary	9	Cannot create in Access designer but can be created in DAO
dbBoolean	1	Yes/No
dbByte	2	Number, Field Size=Byte
dbChar	18	Cannot create in Access, but can be used by linked tables
dbComplexByte	102	Number, Field Size=Byte
dbComplexDecimal	108	Cannot create in DAO but can create in Access designer
dbComplexDouble	106	Number, Field Size=Double
dbComplexGUID	107	Number, Field Size=Replication ID
dbComplexInteger	103	Number, Field Size=Integer
dbComplexLong	104	Number, Field Size=Long Integer
dbComplexSingle	105	Number, Field Size=Single
dbComplexText	109	Text
dbCurrency	5	Currency
dbDate	8	Date/Time
dbDecimal	20	Cannot create in DAO but can create in Access designer
dbDouble	7	Number, Field Size=Double
dbFloat	21	Cannot create in Access, but can be used by linked tables
dbGUID	15	Number, Field Size=Replication ID
dbInteger	3	Number, Field Size=Integer
dbLong	4	Number, Field Size=Long Integer
dbLongBinary	11	Number, Field Size=OLE Object
dbMemo	12	Memo
dbNumeric	19	Cannot create in Access, but can be used by linked tables
dbSingle	6	Number, Field Size=Single
dbText	10	Text
dbTime	22	Cannot create in Access, but can be used by linked tables
dbTimeStamp	23	Cannot create in Access, but can be used by linked tables
dbVarBinary	17	Cannot create in Access, but can be used by ...