ActiveControl Datasheet Caption, Tag or ControlTip text

[detrie]

Access 2003

I have multiple bound text controls on a form.

I am using this to output the Control Names and values to a table.
I am getting results like:

Form Field: txtCompany
Form Value: ABC Corporation

rst!FormField = Screen.ActiveControl.Name
rst!FormValue = Screen.ActiveControl

I'd like to make the Form Field more "friendly".

Form Field: Company Legal Name
Form Value: ABC Corporation

I am thinking I could use control's Datasheet Caption, Tag or ControlTip text. Is that even possible? what would that syntax look like?

.. I'm not inclined to change the control names as I use them in various events.

Thanks

 

[detrie]

RESOLVED!

I was struggling for a while before I posted but have found my answer

Thanks

 rst!FormField = Screen.ActiveControl.ControlTipText