DataTypeEnum enumeration (DAO)

Applies to: Access 2013, Office 2013

Specifies the operational data type of an object.

Name	Value	Description
dbAttachment	101	Attachment data
dbBigInt	16	Big Integer data
dbBinary	9	Binary data
dbBoolean	1	Boolean (True/False) data
dbByte	2	Byte (8-bit) data
dbChar	18	Text data (fixed width)
dbComplexByte	102	Multi-valued byte data
dbComplexDecimal	108	Multi-value decimal data
dbComplexDouble	106	Multi-value double-precision floating-point data
dbComplexGUID	107	Multi-value GUID data
dbComplexInteger	103	Multi-value integer data
dbComplexLong	104	Multi-value long integer data
dbComplexSingle	105	Multi-value single-precision floating-point data
dbComplexText	109	Multi-value Text data (variable width)
dbCurrency	5	Currency data
dbDate	8	Date value data
dbDecimal	20	Decimal data (ODBCDirect only) NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
dbDouble	7	Double-precision floating-point data
dbFloat	21	Floating-point data (ODBCDirect only)
dbGUID	15	GUID data
dbInteger	3	Integer data
dbLong	4	Long Integer data
dbLongBinary	11	Binary data (bitmap)
dbMemo	12	Memo data (extended text)
dbNumeric	19	Numeric data (ODBCDirect only)
dbSingle	6	Single-precision floating-point data
dbText	10	Text data (variable width)
dbTime	22	Data in time format (ODBCDirect only)
dbTimeStamp	23	Data in time and date format (ODBCDirect only)
dbVarBinary	17	Variable Binary data (ODBCDirect only)
dbDateTimeExtended	26	Date/Time Extended