MultiRow Property

Microsoft Access Visual Basic

expression.MultiRow

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

Remarks

The MultiRow property uses the following settings.

Setting Visual Basic Description
Yes True Multiple rows are allowed.
No False (Default) Multiple rows aren't allowed.

Note  You can set the MultiRow property by using the control's property sheet, a macro, or Visual Basic.

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

When the MultiRow property is set to True, the number of rows is determined by the width and number of tabs. The number of rows may change if the control is resized or if additional tabs are added to the control.

When the MultiRow property is set to False and the width of the tabs exceeds the width of the control, navigation buttons appear on the right side of the tab control. You can use the navigation buttons to scroll through all the tabs on the tab control.

Example

To return the value of the MultiRow property for a tab control named "Details" on the "Order Entry" form, you can use the following:

Dim b As Boolean
b = Forms("Order Entry").Controls("Details").MultiRow

To set the value of the MultiRow property, you can use the following:

Forms("Order Entry").Controls("Details").MultiRow = True