Field.Type Property (DAO)

Office 2013 and later

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.

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.