Field2 Members (DAO)

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. .

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

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

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).