I am using this code to put the value of a field into a MsgBox.
Private Sub pre_race_comment_Click()
field_name = Screen.ActiveControl
If Not IsNull(field_name) Then
The reason is that I have 4 fields which are very long, and do not fit into the report, so they are truncated in the report. If they click on one of these fields, it brings up the whole field in a MsgBox. But it would be much better from my point of view of they could click on any field in the report, and it brings up the whole value in a MsgBox.
So what I would need is for the VBA to be triggered by a report event rather than a field event, then the VBA would work out which field was clicked, and bring it up in a MsgBox.