[MS_AccessPros] How do I select text boxes from the controls collection?

 

In the snippet of code below, what can I do to debug.print just the text
box controls? The form has labels and other controls as well as text
boxes. What is the "something?" and "something else?" that will make the
If statement work?

Dim ctl As Control
For Each ctl In Me.Controls
     If ctl.something? = something else? Then
         Debug.Print ctl.Name
     End If
Next ctl

Thanks.
Steve

__._,_.___

---

Posted by: Steve thaw5 <thaw5@suddenlink.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___