Field members (DAO)

Applies to: Access 2013, Office 2013

A Field object represents a column of data with a common data type and a common set of properties.

Methods

Name	Description
AppendChunk	Appends data from a string expression to a Memo or Long Binary Field object in a Recordset.
CreateProperty	Creates a new user-defined Property object (Microsoft Access workspaces only).
GetChunk	Returns all or a portion of the contents of a Memo or Long Binary Field object in the Fields collection of a Recordset object.

Properties

Name	Description
AllowZeroLength	Sets or returns a value that indicates whether a zero-length string ("") is a valid setting for the Value property of the Field object with a Text or Memo data type (Microsoft Access workspaces only).
Attributes	Sets or returns a value that indicates one or more characteristics of a Field object. Read/write Long.
CollatingOrder	Returns a value that specifies the sequence of the sort order in text for string comparison or sorting (Microsoft Access workspaces only). Read-only Long.
DataUpdatable	Returns a value that indicates whether the data in the field represented by a Field object is updatable.
DefaultValue	Sets or returns the default value of a Field object. For a Field object not yet appended to the Fields collection, this property is read/write (Microsoft Access workspaces only).
FieldSize	Returns the number of bytes used in the database (rather than in memory) of a Memo or Long Binary Field object in the Fields collection of a Recordset object.
ForeignName	Sets or returns a value that specifies the name of the Field object in a foreign table that corresponds to a field in a primary table for a relationship (Microsoft Access workspaces only).
Name	Returns or sets the name of the specified object. Read/write String if the object has not been appended to a collection. Read-only String if the object has been appended to a collection.
OrdinalPosition	Sets or returns the relative position of a Field object within a Fields collection. .
OriginalValue	One of the WorkspaceTypeEnum values.	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. Returns the value of a Field in the database that existed when the last batch update began (ODBCDirect workspaces only).
Properties	Returns the Properties collection of the specified object. Read-only.
Required	Sets or returns a value that indicates whether a Field object requires a non-Null value.
Size	Returns the number of bytes used in the database (rather than in memory) of a Memo or Long Binary Field object in the Fields collection of a Recordset object.
SourceField	Returns a value that indicates the name of the field that is the original source of the data for a Field object. Read-only String.
SourceTable	Returns a value that indicates the name of the table that is the original source of the data for a Field object. Read-only String.
Type	Sets or returns a value that indicates the operational type or data type of an object. Read/write Integer.
ValidateOnSet	Sets or returns a value that specifies whether or not the value of a Field object is immediately validated when the object's Value property is set (Microsoft Access workspaces only).
ValidationRule	Sets or returns a value that validates the data in a field as it's changed or added to a table (Microsoft Access workspaces only). Read/write String.
ValidationText	Sets or returns a value that specifies the text of the message that your application displays if the value of a Field object doesn't satisfy the validation rule specified by the ValidationRule property setting (Microsoft Access workspaces only). Read/write String.
Value	Sets or returns the value of an object. Read/write Variant.
VisibleValue	One of the WorkspaceTypeEnum values.	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. Returns a value currently in the database that is newer than the OriginalValue property as determined by a batch update conflict (ODBCDirect workspaces only).