identifying controls

[Guest]

I am trying to cycle through the controls collection in a form and identify a
control by the name property. First I narrow the filed by identifying the
textboxes which is the type of control I am trying to identify. The purpose
of this is to find empty controls. When I use a Select case structure it
fails to stop at the appropriate case even though if I debug.print
control.name it gives me the appropriate name of the control.

Select Case Control.name
Case txtName 'actual control name
end select

Does not execute.
What am I missing?
Thanks.

 

[Brendan Reynolds]

String literals need to be enclosed in quotes ...

Case "txtName"

 

[Guest]

Silly me. thanks. Must be doing this too late at night.