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



stewart wrote:
>
> 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

On Sep 13, 8:55 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> It worked ok for me.
>
> Maybe you need:
>
> if lcase(c.name) = "txtnum1" then
>
>
>
> stewart wrote:
>
> > 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

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



stewart wrote:
>
> On Sep 13, 8:55 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> > It worked ok for me.
> >
> > Maybe you need:
> >
> > if lcase(c.name) = "txtnum1" then
> >
> >
> >
> > stewart wrote:
> >
> > > 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
>
> 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

On Sep 13, 9:38 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> One way is to just look at the leftmost 6 chars:
>
> if left(lcase(c.name),6) = "txtnum" then
>
>
>
> stewart wrote:
>
> > On Sep 13, 8:55 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> > > It worked ok for me.
>
> > > Maybe you need:
>
> > > if lcase(c.name) = "txtnum1" then
>
> > > stewart wrote:
>
> > > > 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
>
> > 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

thank you