Changing the Caption Property of a Query Tab ?

[wilderfan]

When I create forms, I often use the naming convention frmNameOfForm.
Then I will change the caption property of the form so that the tab of the form does NOT show frmNameOfForm. I replace it with something more user friendly.

I'd like to do the same for my queries.

Is it possible to change the caption property of the query so that it does not show qryNameOfQuery on the tab?

 

[boblarson]

No, if you want it to look a certain way it will need to be named that.

 

[wilderfan]

Thanks for confirming, Bob.

You have saved me from "spinning my wheels".

 

[Gina]

There is a way to do this, in your query, click on the column you would like to caption and click on view properties (or alt-enter), the "field properties" box should load. There is a property titled caption. Whatever you type in there, will appear when your query is displayed.

 

[techexpressinc]

Thanks a million - I had a field in a query I was trying to rename the normal way.
NewName: OldName
But it was failing. I knew the field had a caption. I tried this:
NewName: Caption
This failed.
I tried other techniques failing. 1.5 hrs later....
Then I found this! and it worked.
Russ

 

[techexpressinc]

I added a picture, showing how to rename a field with a caption with a query.
I forgot, it has been 3 years. And I was trying within the query screen to do it with newnameldname. That method was failing and failing. So, I did a search and found this gem, a refresher.
Russ

 

[startingover0001]

The caption property does NOT work. Even though you add a caption in the properties sheet, once saved and you come back to it, it reverts back to the original name.

 

[isladogs]

It works for me using A2010.
However, if I want to use a field caption I normally just do this in the designer window using a colon. For example:
Caption:FieldName

 

[June7]

Why bother? Users should not interact with tables and queries. When I (developer) view tables and queries I prefer to see the real info - data and field names. Captions are for forms and reports.

Original question was about the query 'tab' caption (no such property), not field caption.

Should have started your own thread instead of piggy-backing on a very old thread that is not even related to issue.

However, just tested, and the caption is saved and displays when opening query. I just don't see benefit, just causes confusion. Referencing that query in another query will see the actual names, not the captions.

 

[isladogs]

Why bother? ... I just don't see benefit, just causes confusion. Referencing that query in another query will see the actual names, not the captions.

I agree that this just causes confusion but adding a field caption IS carried forward if the query is referenced in another query.
The second query design will show the field name but when the query is run it displays the caption. Not at all helpful in my opinion.

 

[June7]

Exactly, the Design window shows the actual field names. So if you are looking at an open table/query with captions, then start to build a query referencing that object, you see field names not captions. Just annoying and confusing. And if you really get lost and try to use caption in an expression in query, will get popup prompt and in textbox Name!.