Forum Discussion

MarySmith2020's avatar
MarySmith2020
Copper Contributor
May 06, 2020
Solved

Table Alias in Access 2019

In Access 2016 and earlier, in a query, you can set an alias for a table by clicking on the table and showing the Property Sheet.  This opened what used to be the "Field List Properties" with a "General" tab with two properties:  Alias and Source.

 

In my new Access 2019, I cannot bring up this "table" Property Sheet!  When I click on the table and bring up the properties, I am seeing the properties of the last selected query object.  Clicking on the table does not change the property window.

 

Is there a setting I have wrong in my new Access 2019?  Did MS do away with the Field List Properties for tables??

 

I apparently can go into SQL and create an alias there that will be reflected in the QBE grid, but I have no idea how to change it in the QBE interface!

  • MarySmith2020 I found where it has been reported to the MS Access team at Microsoft and they are investigating it. I don't know when a fix will be available. 

4 Replies

      • George Hepworth's avatar
        George Hepworth
        Steel Contributor

        MarySmith2020 I found where it has been reported to the MS Access team at Microsoft and they are investigating it. I don't know when a fix will be available. 

Resources