Add Method (SchemaFields Collection)

                  Applies To

Creates a new schema field. Returns a SchemaField object.

Syntax

expression.Add(Name, DataType, Length)

expression   An expression that returns a SchemaFields object.

Name   Required String. Specifies the name of the new schema field.

DataType   Required ADO DataTypeEnum. Specifies the data type of the new schema field.

Length   Optional Variant. Specifies the length of the new schema field.

Remarks

In design mode in Microsoft Access, the SchemaFields collection is automatically filled with the available schema fields.