How to rename a query or report displayed on title bar.

[axilla2]

So, I created a bunch of reports and queries with these convoluded names like qryDailyRptANC. Without realizing that the name I gave it is going to appear on all headers and exports.

Too late to change now b/c these names are hardcoded into buttons and actions.

I wonder if there is a way to assign an alias to a report or query so that the alias name is displayed to the user on the header instead.

I know, I can simply create another query, feed it off the original(select * from ..) and name it whatever I want.. but nevermind that, i wonder if there's an easier way just to assign it a different name to display on the front end.

thanks-

 

[Lightning]

For Forms and Reports, use the Caption property to display a more meaningful name in the titlebar. The caption is just a label, it doesn't affect the Name property and therefore won't affect your code.

Unfortunately, there is no Caption property for queries.

HTH
Lightning