Field2 Object Members

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 Binary Field2 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).
	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 the name of the specified object. Read/write String if the object has 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	ODBCDirect workspaces are not supported in Microsoft Office Access 2007. 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	ODBCDirect workspaces are not supported in Microsoft Office Access 2007. 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).