Cycle property
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.