Text box properties - debug printing

[Middlemarch]

Looking at Text Box properties the first 3 entries are




Name
Label Name
Control Source


So I try:

For Each ctl In Form_xxx.subFormyyyy.Controls
        If ctl.ControlType = acTextBox Then
            Debug.Print ctl.Name, ctl.ControlSource, ctl.LabelName
        End If
Next

This gives an error on LabelName. I can't leave in the space and ctl.[Label Name]
doesn't work eitehr. But the space in "Control Source" can be removed and no error.
Why not the same for label name and how can it be debug printed?
Thanks.

[davegri]

A label is a control in its own right, and apparently not a property of its textbox owner.

    For Each ctl In Form_xxx.subFormyyyy.Controls
        Select Case ctl.ControlType
            Case acTextBox
                Debug.Print ctl.Name, ctl.ControlSource
            Case acLabel
                Debug.Print ctl.Name
        End Select
    Next

[June7]

If a control has an associated label, that label is an element of the control.

Middlemarch, you've already used it in other thread discussion:

ctl.Controls(0).Caption

Code will error if control does not have associated label (as I noted in other thread).

I do not see Label Name property. Must be feature added after Access2010. Even if there is now a Label Name property displayed, code likely still uses the old syntax to reference associated label.

[señor_sriracha]

Name
Label Name
Control Source

For Each ctl In Form_xxx.subFormyyyy.Controls
        If ctl.ControlType = acTextBox Then
            Debug.Print ctl.Name, ctl.ControlSource, ctl.LabelName
        End If
Next

Try:

ctl.Properties("LabelName")

[CJ_London]

This is not valid code and will error

For Each ctl In Form_xxx.subFormyyyy.Controls​

you are missing a .form

For Each ctl In Form_xxx.subFormyyyy.form.Controls

[June7]

CJ, I tested this code. It works with or without .Form qualifier. Related thread https://www.accessforums.net/showthread.php?t=89874

[Middlemarch]

Thank you senor that was helpful,
I have 2 functions that use Select Case that might be improved . One is sent a label caption and returned the control name.
The other gets the control name and returns the label caption.
I did it this was as the Form_Form syntax was just so hard to get right.
The Form name is frmMain and its Subform is SubDisplay

[CJ_London]

It works with or without .Form qualifier

New one on me