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 |
---|---|
Appends data from a string expression to a Memo or Long Binary Field2 object in a Recordset. |
|
Creates a new user-defined Property object (Microsoft Access workspaces only). |
|
Returns all or a portion of the contents of a Memo or Long BinaryField2 object in the Fields collection of a Recordset object. |
|
Loads the specified file from disk. |
|
Saves an attachment to disk. . |
Properties
Name |
Description |
|
---|---|---|
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). |
||
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. |
||
Sets or returns a value that indicates one or more characteristics of a Field2 object. Read/write Long. |
||
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. |
||
Returns a ComplexType object that represents a multi-valued field. Read-only. |
||
Returns a value that indicates whether the data in the field represented by a Field2 object is updatable. |
||
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). |
||
Read/write |
||
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. |
||
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). |
||
Returns Boolean that indicates whether the specified field is a multi-valued data type. Read-only. |
||
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. |
||
Sets or returns the relative position of a Field2 object within a Fields collection. . |
||
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). |
|
Returns the Properties collection of the specified object. Read-only. |
||
Sets or returns a value that indicates whether a Field2 object requires a non-Null value. |
||
Sets or returns a value that indicates the maximum size, in bytes, of a Field2 object. |
||
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. |
||
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. |
||
Sets or returns a value that indicates the operational type or data type of an object. Read/write Integer. |
||
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). |
||
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. |
||
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. |
||
Sets or returns the value of an object. Read/write Variant. |
||
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). |