<div>
once the form is open you can loop through all controls <br />

<pre><code class="code-1 nolinks" id="code-20-40449006-1"><span>      For Each ctl In Forms(frm.Name).Controls</span>
<span>         If ctl.ControlType = acLabel Then</span>
<span>            rs.AddNew</span>
<span>            rs!ObjectCaption = Forms(frm.Name).Caption</span>
<span>            rs!ObjectName = frm.Name</span>
<span>            rs!ObjectLabel = ctl.Name</span>
<span>            rs.Update</span>
<span>         End If</span>
<span>      Next ctl</span>
</code></pre>
</div>


<div>
if you want to list the associated label you can add this code <br />

<pre><code class="code-1 nolinks" id="code-20-40449013-1"><span>            On Error Resume Next</span>
<span>            rs!ObjectLabel = ctl.Controls.Item(0).Caption</span>
<span>            On Error GoTo 0</span>
</code></pre>
</div>


<div>
Hi Gozreh, <br />
Thank You for responding. <br />
The post ID : 40449013 does not return the label caption.<br />
Kind Regards, <br />
Mohamed
</div>


<div>
Hi Gozreh, <br />
Great stuff!<br />
That works perfectly. <br />
Kind Regards, <br />
Mohamed
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
A more challenging request than my last question:<br />
I need to list the captions of the labels of all controls of all forms to tblMyTable.ObjectLabel<br />
The respective Form name should be written to tblMyTable.ObjectName <br />
(I'm unsure as to whether the control to which the label is associated/attached could also be listed to tblMyTable.ControlName since, I expect, I would first need to ensure that each Label is indeed associated with a control).<br />
Your Assistance would be greatly appreciated. <br />
Kind Regards, <br />
Mohamed
</div>
</div>


Hi,
A more challenging request than my last question:
I need to list the captions of the labels of all controls of all forms to tblMyTable.ObjectLabel
The respective Form name should be written to tblMyTable.ObjectName 
(I'm unsure as to whether the control to which the label is associated/attached could also be listed to tblMyTable.ControlName since, I expect, I would first need to ensure that each Label is indeed associated with a control).
Your Assistance would be greatly appreciated. 
Kind Regards, 
Mohamed

MS Access Loop Through All Forms and Write Label Captions to Table

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.