Expose Control name during loop the .controls collection of Form.

[Guest]

How is it that the name of the the control or the
control's name property can get exposed through
the .controls collection of the form object?

I want to loop through the control collection and validate
some business logic - from this point I want to know what
the name or name property of the control I am in during
loop.. Then I can use it in msgbox function or setfocus
function if the validation fails (False). Thanks for your
help.

I already know how to loop, just don't know how to expose
the name of control.

Thanks

Marcel K.

"Me.Controls.Item(indx)"

 

[Rob]

Me.Controls.Item(indx).Name is the name of the control (ie
txtLastName)
Me.Controls.Item(indx).value is what is IN the control
(Text value usually)