Form.Controls property (Access)

  • Article

Returns the Controls collection of a form, subform, report, or section. Read-only Controls.

Syntax

expression.Controls

expression A variable that represents a Form object.

Remarks

Use the Controls property to refer to one of the controls on a form, subform, report, or section within or attached to another control. For example, the first code syntax returns the number of controls located on Form1. The second references the name of a property within a control.

Forms("Form1").Controls.Count 
 
Forms("Form1").Controls("Textbox1").Properties(5).Name

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.