This documentation is archived and is not being maintained.

ListWidth Property [Access 2003 VBA Language Reference]

Office 2003

You can use the ListWidth property to set the width of the list box portion of a combo box. Read/write String.

expression.ListWidth

expression Required. An expression that returns one of the objects in the Applies To list.

Remarks

The ListWidth property holds a value specifying the width of the list box portion of a combo box in inches or centimeters, depending on the measurement system (U.S. or Metric) selected in the Measurement system box on the Numbers tab of the Regional Options dialog box of Windows Control Panel. To use a unit other than the default, include a measurement indicator, such as cm or in. The default setting (Auto) makes the list box portion of the combo box the same width as the combo box.

You can set the ListWidth property by using the combo box's property sheet , a macro , or Visual Basic .

For table fields , you can set this property on the Lookup tab of the Field Properties section of table Design view for fields with the DisplayControl property set to Combo Box.

ListWidth

In Visual Basic, use a numeric expression to set the value of this property. The default unit of measurement in Visual Basic is twips.

You can also set the default for this property by using a combo box's default control style or the DefaultControl property in Visual Basic.

The list portion of the combo box can be wider than the combo box but can't be narrower.

If you want to display a multiple-column list, enter a value that will make the list box wide enough to show all the columns.

Example

The following example returns the value of the ListWidth property for the "States" combo box on the "Order Entry" form.

Dim str As String
str = Forms("Order Entry").Controls("States").ListWidth
		


Applies to | ComboBox Object



Show: