Beginning Access 1002002 Vba [Electronic resources]

Robert Smith; Dave Sussman Et al

نسخه متنی -صفحه : 256/ 207

Field

Methods

Name	Returns	Description
AppendChunk		Appends binary or textual data to the end of the field.
CreateProperty	Property	Creates a user-defined property.
GetChunk	Variant	Retrieves binary or textual data from the field.

Name

Returns

Description

AppendChunk

Appends binary or textual data to the end of the field.

CreateProperty

Property

Creates a user-defined property.

GetChunk

Variant

Retrieves binary or textual data from the field.

Properties

Name	Returns	Description
AllowZeroLength	Boolean	Indicates whether or not the field can be zero length.
Attributes	Long	Indicates the characteristics of a Field . Can be one or more of the FieldAttributeEnum constants.
CollatingOrder	Long	Identifies the sort sequence for the field.
DataUpdatable	Boolean	Indicates whether or not the field data can be updated. Read-only.
DefaultValue	Variant	Indicates the default value for the field.
FieldSize	Long	Indicates the size, in bytes, of the field.
ForeignName	String	If the field participates in a relationship, this identifies the name of the field in the foreign table.
Name	String	The name of the field.
OrdinalPosition	Integer	Indicates the relative position of the Field in the Fields collection.
OriginalValue	Variant	For ODBCDirect , indicates the value of the field before the last update was performed. Read-only.
Properties	Properties	Collection of Property objects. Read-only.
Required	Boolean	Indicates whether or not the field is compulsory.
Size	Integer	Indicates the maximum size, in bytes, of the field
SourceField	String	Indicates the name of the field that is the original source of the data. Read-only.
SourceTable	String	Indicates the name of the table that is the original source of the data. Read-only.
Type	Integer	Indicates the type of data the field holds.
ValidateOnSet	Boolean	Indicates whether or not validation takes place as soon as the value of the field is changed.
ValidationRule	String	An expression that is the rule for validation.
ValidationText	String	Text to display of validation fails.
Value	Variant	The current value of the field.
VisibleValue	Variant	For ODBCDirect , the value in the database, as opposed to a value that might not yet have been sent to the database. Read-only.

Name

Returns

Description

AllowZeroLength

Boolean

Indicates whether or not the field can be zero length.

Attributes

Long

Indicates the characteristics of a

Field . Can be one or more of the

FieldAttributeEnum constants.

CollatingOrder

Long

Identifies the sort sequence for the field.

DataUpdatable

Boolean

Indicates whether or not the field data can be updated. Read-only.

DefaultValue

Variant

Indicates the default value for the field.

FieldSize

Long

Indicates the size, in bytes, of the field.

ForeignName

String

If the field participates in a relationship, this identifies the name of the field in the foreign table.

Name

String

The name of the field.

OrdinalPosition

Integer

Indicates the relative position of the

Field in the Fields collection.

OriginalValue

Variant

For

ODBCDirect , indicates the value of the field before the last update was performed. Read-only.

Properties

Collection of

Property objects. Read-only.

Required

Boolean

Indicates whether or not the field is compulsory.

Size

Integer

Indicates the maximum size, in bytes, of the field

SourceField

String

Indicates the name of the field that is the original source of the data. Read-only.

SourceTable

String

Indicates the name of the table that is the original source of the data. Read-only.

Type

Integer

Indicates the type of data the field holds.

ValidateOnSet

Boolean

Indicates whether or not validation takes place as soon as the value of the field is changed.

ValidationRule

String

An expression that is the rule for validation.

ValidationText

String

Text to display of validation fails.

Value

Variant

The current value of the field.

VisibleValue

Variant

For

ODBCDirect , the value in the database, as opposed to a value that might not yet have been sent to the database. Read-only.