Query column titles ignores the alias provided

[roulette6]

Hello:

I wonder whether others are having this same issue. I created a database a while ago which I used as the template for creating other databases that required changes to the tables, queries, and forms. I mention this in case this is relevant.



In one of the databases I work with, I've noticed that if I provide alias for fields, the query disregards them and instead shows the field name on the table. If I assign a caption to a field via the property sheet, then the query shows that information. I suppose this takes care of my problem, but I hate that this bug is affecting me and makes me wonder what else might not be working correctly. Any thoughts/advice?

[orange]

Can you please describe the bug in more detail? Perhaps an example showing What happens and WHAT you expect to happen.