Purpose
Field objects define a specific field for TableDef, QueryDef, Index, Relation or Recordset
Accesses/Assigns
AllowZeroLength | Indicates whether a zero-length string is valid for this field |
Attributes | Miscellaneous characteristics of a Field object |
CollectionIndex | Returns the position of a Field within its Fields collection, as indicated by a 0-based integer. |
DataUpdatable | Indicates whether the data in the field is updatable |
Name | The name of this object |
Required | Indicates whether the Field requires a non-Null value |
Size | Maximum size of the field |
SourceField | Name of the original source field in the underlying table |
Type | Indicates the data type of the object |
ValidateOnSet | False delays validation until Update, True validates a new value immediately. |
ValidationRule | Specifies an expression that must evaluate True for a successful update |
Value | Returns or resets the value of an object (optional) |
Methods
Inherits from
See Also
Example
Fields Sample