check control names

  • Thread starter Thread starter stewart
  • Start date Start date
S

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)
 
It worked ok for me.

Maybe you need:

if lcase(c.name) = "txtnum1" then
Click to expand...

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
 
One way is to just look at the leftmost 6 chars:

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