How to get a list of field display labels and database table and column names from an Access Front end RRS feed

  • Question

  • Hi

    We have a legacy Microsoft Access front and database file (.accdb ). Think this is access 2010.

    This is the front end of an application (data is stored in a SQL server database)

    There are some complicated forms with dozens of fields on them. We need to migrate data and would like to match up the display labels that the users see when they use the application to the database column names (in SQL).

    Is there a way to query the Access database system tables to list the form field display name and the Sql table and column name that each field is linked to ?



    Monday, June 1, 2020 11:11 AM

All replies

  • You could start with the Database Documenter under the Database Tools tab of the Ribbon.

    -Tom. Microsoft Access MVP

    Monday, June 1, 2020 1:43 PM
  • You have to query all the controls (

    This is a quick and dirty sample...you can extend it to your liking

    Function getAllControls

    On Error Resume Next

    Dim ctl as Control

    For each ctl in Me.Controls

    Debug.print ctl.Name & " - " & ctl.ControlSource


    End Function

    Wednesday, June 3, 2020 8:55 AM