Convert Active Control Name

[moke123]

Probably could do something like

    Dim qdf As DAO.QueryDef
    Dim fld As Field
    Dim strOut As String


    Set qdf = CurrentDb.CreateQueryDef("", Me.RecordSource)


    For Each fld In qdf.Fields
        strOut = strOut & "Name: " & fld.Name & vbTab & "Position: " & fld.OrdinalPosition & vbTab & _
                            "size: " & fld.Properties("size") & vbTab & "Type: " & fld.Type & vbNewLine & vbNewLine
    Next


    MsgBox strOut

lots of properties available https://learn.microsoft.com/en-us/of...properties-dao

Personally I would debug.print instead of msgbox.

[Minty]

I didn't answer answer @Minty as I wasn't sure what to say. It seemed obvious, wanting to know about your data and its structure etc.
In this particular case I was building a Msgbox of all 'parts' of my field, instantly showing their names and addressing to help me with coding.

Now I understand! An development assistant.

I could see no real use of this in an application that would make any sense, hence my quizzicalness (that's not really a word is it...).