Adds a field to the current table.
In the Database form, select a table, and click the Right mouse button. Then, in the Table Structure dialog box, click the Add Field button to display the Add Field dialog box.
Name
Allows you to type the name of the field you want to add.
OrdinalPosition
Allows you to determine the relative position of the field.
Type
Lets you determine the operational or data type of the field.
ValidationText
Lets you add the text of the message that your application displays if a user tries to enter an invalid value for a field.
Size
Lets you determine the maximum size, in bytes, of the field.
FixedField — If selected, creates a field with a fixed size.
VariableField — If selected, allows the user to modify the size of the field by dragging its borders.
ValidationRule
Lets you determine what data is valid in a field as it is added.
DefaultValue
Lets you determine the default value for the field.
AutoIncrField
Automatically adds the next field if you are at the end of the table.
AllowZeroLength
Allows you to have a zero-length string as a valid setting.
Required
Indicates if the field requires a non-Null value.
Add
Appends the current Field definition to the current table.
Close
Closes the form when you are finished adding fields.
Note All items, such as ValidationText and Ordinal Position, are Field properties, and are described in detail in the Visual Basic Help file. Those that do not apply are not available.