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

 

Doh! Didn't check my copy & paste close enough. Thanks, Duane.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <duanehookom@hotmail.com> wrote :

Remove the "?" in the code which would be found when compiling.

Duane

On May 5, 2018, at 4:52 PM, "'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Steve

 

Not too tough.

 

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

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
That'll do IT http://thatlldoit.com

My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, May 04, 2018 6:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

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

.

__,_._,___