Field.Type property (DAO)

Applies to: Access 2013, Office 2013

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.