Code for calling the actual Column history RRS feed

  • Question

  • Hello,

    is there a code to imitate the right click show column history of the actual record - i know the following script:

    ub colhist()
        Dim sHistory As String
        sHistory = Application.ColumnHistory("Employees", "Salary", "ID=147")
        Debug.Print sHistory
    End Sub

    But i need the actual record and no debug print but the messagebox that is used by the system.

    Thank you very much and sorry for my english


    Sunday, April 1, 2018 9:15 AM


  • If you want to display the column history dialog, you can set focus to the field you want to inspect, and use

    RunCommand acCmdShowColumnHistory

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, April 1, 2018 10:20 AM