Column object (ADOX)

Applies to: Access 2013, Office 2013

Represents a column from a table, index, or key.


The following code creates a new Column:

Dim obj As New Column

With the properties and collections of a Column object, you can:

  • Identify the column with the Name property.

  • Specify the data type of the column with the Type property.

  • Determine if the column is fixed-length, or if it can contain null values with the Attributes property.

  • Specify the maximum size of the column with the DefinedSize property.

  • For numeric data values, specify the scale with the NumericScale property.

  • For numeric data value, specify the maximum precision with the Precision property.

  • Specify the Catalog that owns the column with the ParentCatalog property.

  • For key columns, specify the name of the related column in the related table with the RelatedColumn property.

  • For index columns, specify whether the sort order is ascending or descending with the SortOrder property.

  • Access provider-specific properties with the Properties collection.


Not all properties of Column objects may be supported by your data provider. An error will occur if you have set a value for a property that the provider does not support. For new Column objects, the error will occur when the object is appended to the collection. For existing objects, the error will occur when setting the property.

When creating Column objects, the existence of an appropriate default value for an optional property does not guarantee that your provider supports the property. For more information about which properties your provider supports, see your provider documentation.