check control names

[stewart]

I would like to be able to run a code that will check to see if a
control has a particular name and then tell me which one has that
name. I thought the code below would work but it does not do the
trick.

Private Sub btnSubmit_Click()

Dim C As Control
For Each C In Me.Controls
If C.Name = "txtnum1" Then
MsgBox C.Name
End If
Next C


End Sub

Additionally is there a way to use a wild card. For example show me
all textboxes that start with txtNum (txtNum1, txtNum2, etc)

 

[Dave Peterson]

It worked ok for me.

Maybe you need:

if lcase(c.name) = "txtnum1" then

 

[stewart]

It worked ok for me.

Maybe you need:

if lcase(c.name) = "txtnum1" then

that did the trick...now is there a way to change that so i can search
for a wildcard. i want to find all textboxes that begin with txtNum

 

[Dave Peterson]

One way is to just look at the leftmost 6 chars:

if left(lcase(c.name),6) = "txtnum" then

 

[stewart]

One way is to just look at the leftmost 6 chars:

if left(lcase(c.name),6) = "txtnum" then

thank you