Field Name aliases - A2007

[Lynn Trapp]

I just noticed something that I have never observed before. When writing an
SQL query in A2007, if the field name of the table has the Caption property
set to some value, the caption property will display as the column name even
if I add an Alias for the field name. For example, if I have a field named
strPhone with a caption property of Phone 1 it will display as Phone 1 even
if I write the following query with an Alias.

SELECT strPhone As Contact
FROM MyTable;

I don't have an earlier version of Access available to me at the moment and
I'm wondering if this has always been the case or is it something new in
A2007. To my mind the Alias in the SQL statement should win out over the
caption property.

 

[johnlute]

Hi, Lynn.

I run Access 2003 and noticed this a long time ago. I found it really
annoying and decided to simply eliminate table captions.

 

[Lynn Trapp]

Hi John,

I verified that in 2003 when I got home from work. It really is annoying.


Lynn Trapp

 

[johnlute]

Hi, Lynn.

I recall the first time I noticed it and was really confused. I
figured that the alias would win out over the caption, too but NO!

I've had to go back and delete a lot of captions!