check control names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stewart - 14 Sep 2007 01:31 GMT

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)

Reply to this Message

Dave Peterson - 14 Sep 2007 01:55 GMT

It worked ok for me.

Maybe you need:

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

> 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
[quoted text clipped - 14 lines]
> Additionally is there a way to use a wild card. For example show me
> all textboxes that start with txtNum (txtNum1, txtNum2, etc)

Signature

Dave Peterson

Reply to this Message

stewart - 14 Sep 2007 02:06 GMT

> It worked ok for me.
>
[quoted text clipped - 24 lines]
>
> Dave Peterson

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

Reply to this Message

Dave Peterson - 14 Sep 2007 02:38 GMT

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

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

> > It worked ok for me.
> >
[quoted text clipped - 27 lines]
> 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

Signature

Dave Peterson

Reply to this Message

stewart - 14 Sep 2007 11:21 GMT

> One way is to just look at the leftmost 6 chars:
>
[quoted text clipped - 35 lines]
>
> Dave Peterson

thank you

Reply to this Message