How to access the label of a control in code

ms-access, vba

Solution

With the textbox you can try

Text0.Controls.Item(0).Caption

where Control 0 is the linked label

Problem

Often a label control is bound to a textbox or similar other control. I know that there is a way to access the label through code, but I do not remember how to do it. Can anyone help? Maybe something like: ``` Me.txtName.Child!lblName.Value ``` Or ``` Me.txtName.Parent!lblName.Value ``` I will use this when I am enumerating through the controls on a form for validation purposes. Then I want to use the label for a control as information in the error message to show the user where the error is.

Original source