ColumnWidth Property
Applies To
Bound Object Frame control, Chart control, Check Box control, Combo Box control, Field object, List Box control, Option Button control, Option Group control, QueryDef object, Table field, TableDef object, Text Box control, Toggle Button control.
Description
You can use the ColumnWidth property to specify the width of a column in Datasheet view.
Note The ColumnWidth property applies to all fields in Datasheet view and to form controls when the form is in Datasheet view.
Setting
You can set this property by dragging the right border of the column selector or by clicking Column Width on the Format menu in Datasheet view and entering the desired value. When you set the ColumnWidth property by using the ColumnWidth command, the value is expressed in points.
In Visual Basic, the ColumnWidth property setting is an Integer value that represents the column width in twips. You can specify a width or use one of the following predefined settings.
| Setting | Description |
|
| 0 | Hides the column. |
| –1 | (Default) Sizes the column to the default width. |
Remarks
Setting this property to 0, or resizing the field to a zero width in Datasheet view, sets the field's ColumnHidden property to True (–1) and hides the field in Datasheet view.
Setting a field's ColumnHidden property to False (0) restores the field's ColumnWidth property to the value it had before the field was hidden. For example, if the ColumnWidth property was –1 prior to the field being hidden by setting the property to 0, changing the field's ColumnHidden property to False resets the ColumnWidth to –1.
The ColumnWidth property for a field isn't available when the field's ColumnHidden property is set to True.
See Also
ColumnHidden property, ColumnOrder property, RowHeight property.
Example
The following example changes the row height in Datasheet view of the Customers table to display two lines of data (450 twips) and sets the width of the Address column to 1.5 inches (2160 twips). These property settings will take effect the next time the Customers table is opened in Datasheet view.
To set the RowHeight and ColumnWidth properties, the example uses the SetTableProperty procedure, which is shown in the example for the DatasheetFontItalic and DatasheetFontUnderline properties, and the SetFieldProperty procedure, which is shown in the example for the ColumnHidden property.
Dim dbs As Database, tdfCustomers As TableDef
Set dbs = CurrentDb
Set tdfCustomers = dbs![Customers]
SetTableProperty tdfCustomers, "RowHeight", dbLong, 450
SetFieldProperty tdfCustomers![Address], "ColumnWidth", dbInteger, 2160
The next example takes effect in Datasheet view of the open Customers form. It sets the row height to 450 twips and sizes the column to fit the size of the visible text.
Forms![Customers].RowHeight = 450
Forms![Customers]![Address].ColumnWidth = -2