Table of contents
Collapse the table of content
Expand the table of content

BoundObjectFrame.ColumnWidth Property (Access)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

You can use the ColumnWidth property to specify the width of a column in Datasheet view. Read/write Integer.


expression. ColumnWidth

expression A variable that represents a BoundObjectFrame object.


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.

0Hides the column.
?1(Default) Sizes the column to the default width.

Note The ColumnWidth property applies to all fields in Datasheet view and to form controls when the form is in Datasheet view.

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.


This 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

See also


BoundObjectFrame Object

© 2018 Microsoft