Search code examples
vbams-access

How to access the label of a control in code

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.

Solution

  • With the textbox you can try

    Text0.Controls.Item(0).Caption

    where Control 0 is the linked label