Cimber
asked on
Easy way to set control properties in VBA
I want to check and set properties of controls on my form in VBA Access 97.
Currently, I use a For loop to check the name of each control to find the one I want to modify. For example.
For each ctl in Me.Controls
If ctl.Name = "Name_of_Control_I'm_Looki ng_For" then
.... do something
end if
next ctl
Is there a quicker and more efficient way to access a control by its name?
Currently, I use a For loop to check the name of each control to find the one I want to modify. For example.
For each ctl in Me.Controls
If ctl.Name = "Name_of_Control_I'm_Looki
.... do something
end if
next ctl
Is there a quicker and more efficient way to access a control by its name?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER