Edit

Cycle property

  • Article

Specifies the action to take when the user leaves the last control on a Frame or Page.

Syntax

object.Cycle [= fmCycle ]

The Cycle property syntax has these parts:

Part Description
object Required. A valid object.
fmCycle Optional. Specifies whether cycling includes controls nested in a Frame or MultiPage.

Settings

The settings for fmCycle are:

Constant Value Description
fmCycleAllForms 0 Cycles through the controls on the form and the controls of the Frame and MultiPage controls that are currently displayed on the form.
fmCycleCurrentForm 2 Cycles through the controls on the form, Frame, or MultiPage. The focus stays within the form, Frame, or MultiPage until the focus is explicitly set to a control outside the form, Frame, or MultiPage.

If you specify a non-integer value for Cycle, the value is rounded up to the nearest integer.

Remarks

The tab order identifies the order in which controls receive the focus as the user tabs through a form or subform. The Cycle property determines the action to take when a user tabs from the last control in the tab order.

The fmCycleAllForms setting transfers the focus to the first control of the next Frame or MultiPage on the form when the user tabs from the last control in the tab order.

The fmCycleCurrentForm setting transfers the focus to the first control of the same form, Frame, or MultiPage when the user tabs from the last control in the tab order.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.