Field.Type Property (DAO)

Sets or returns a value that indicates the operational type or data type of an object. Read/write Integer.

Syntax

expression .Type

expression A variable that represents a Field object.

Remarks

The setting or return value is a constant that indicates an operational or data type. For a Field object, this property is read/write until the object is appended to a collection or to another object, after which it's read-only.

For a Field object, the possible settings and return values are described in the following table.

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

When you append a new Field, Parameter, or Property object to the collection of an Index, QueryDef, Recordset, or TableDef object, an error occurs if the underlying database doesn't support the data type specified for the new object.