Field

team lib

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.

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.

 
team lib


Beginning Access 2002 VBA
Beginning Access 2002 VBA (Programmer to Programmer)
ISBN: 0764544020
EAN: 2147483647
Year: 2003
Pages: 256

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net