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.