Get the Caption of associated Label for a Form Control - Access 2007

Question

Hi there,

As the title suggests, I'm trying to get the caption of the associated label for form controls eg:

Dim ctl As Control
Dim errMess As String
errMess = ""
For Each ctl In frm
    With ctl
            If (ctl.Tag = "*") Then
        errMess = errMess & ctl.Caption & vbNewLine        
            End If
        End If
   End With
Next ctl 

Obviously "ctl.Caption" doesn't work, I'm just not sure how to reference this.

Any help appreciated.

Cheers

Noel

Answer 1

Found out the answer is to use ctl.Controls.Item(0).Caption

Dim ctl As Control
Dim errMess As String
errMess = ""
For Each ctl In frm
    With ctl
            If (ctl.Tag = "*") Then
        errMess = errMess & ctl.Controls.Item(0).Caption & vbNewLine        
            End If
        End If
   End With
Next ctl