VBA Forms in Access - Control Captions and Control Properties

[NiallWestland1974]

Hi,
I'm trying to dynamically capture the captions of the forms contained in a form and, in addition, set the onchange property of these controls dynamically through VBA.

Does anyone have any ideas on how to solve either (or even one!) of these problems??

The (faulty!) code is:
For i = 0 To Me.Count - 1
If TypeOf Me(i) Is TextBox Then
If i = 0 Then
strTextBoxName = Me(i).Caption
Else
strTextBoxContent = strTextBoxContent & "," & Me(i).Caption
End If
End If
Next i

Thanks

 

[NiallWestland1974]

D'oh - I have the caption problem sorted out - by looking for labels rather than textboxes, the code above basically works:

For i = 0 To Me.Count - 1
If TypeOf Me(i) Is Label Then
If i = 1 Then
AlterTextBox = "Date altered: " & Now() & " - " & Me(i).Caption
Else
AlterTextBox = AlterTextBox & "," & Me(i).Caption
End If
End If
Next i
MsgBox AlterTextBox

HOWEVER, does anyone know if you can add event properties to form controls at run-time?