Field2 members (DAO)

Applies to: Access 2013, Office 2013

A Field2 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 Field2 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 BinaryField2 object in the Fields collection of a Recordset object.
LoadFromFile	Loads the specified file from disk.
SaveToFile	Saves an attachment to disk. .

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 Field2 object with a Text or Memo data type (Microsoft Access workspaces only).
AppendOnly	Gets or sets a Boolean that indicates whether the spcified field is set to append new values to the existing contents of the field as they are added. Read/write.
Attributes	Sets or returns a value that indicates one or more characteristics of a Field2 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.
ComplexType	Returns a ComplexType object that represents a multi-valued field. Read-only.
DataUpdatable	Returns a value that indicates whether the data in the field represented by a Field2 object is updatable.
DefaultValue	Sets or returns the default value of a Field2 object. For a Field2 object not yet appended to the Fields collection, this property is read/write (Microsoft Access workspaces only).
Expression	Read/write
FieldSize	Returns the number of bytes used in the database (rather than in memory) of a Memo or Long Binary Field2 object in the Fields collection of a Recordset object.
ForeignName	Sets or returns a value that specifies the name of the Field2 object in a foreign table that corresponds to a field in a primary table for a relationship (Microsoft Access workspaces only).
IsComplex	Returns Boolean that indicates whether the specified field is a multi-valued data type. Read-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 Field2 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 Field2 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 Field2 object requires a non-Null value.
Size	Sets or returns a value that indicates the maximum size, in bytes, of a Field2 object.
SourceField	Returns a value that indicates the name of the field that is the original source of the data for a Field2 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 Field2 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 Field2 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 Field2 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).