How to show the database name first in the Access window caption in the taskbar?
Posted on 2015-02-23
Ok, the problem is: in the Access 2003, when you opened a database, in the taskbar you would be shown “MyDatabaseName: Database”, and if you would have opened a table, it would be shown “MyTableName: Table”, so if you have several databases opened, you would get instant overview where is each one just by glancing at the taskbar.
In the Assess 2010 (I suppose 2007 too) however, when you open a database, you get “Microsoft Access – MyDatabaseName: Database” as the caption in the taskbar, but, due to a finite length of the window caption in the taskbar (XP, or Win 7 with “Never Combine Taskbar buttons” option enabled), the actual caption in the taskbar is trimmed to “Microsoft Access…”; and now if you have opened multiple databases, you have a bunch of “Microsoft Access…” windows, without that instant overview to what database each of them refer, unless you hover the mouse in the taskbar…
I really would like to know in what state of mind was the person in MS who thought that this change was a good change. Nevertheless, the question now is how to change this behavior to a previous one, or a similar one, so that in the taskbar is shown the database file name first?
I have found that if you set File>Options>Current Database>Application Title, to e.g. Application Title=MyTitle, it would be shown MyTitle in the taskbar, which is ok, however, I don’t want to have to manually have to change the current database Application title for each and every db I open… so alternatively, the question could be: is there a way to tell access to automatically as the Application Title use the current database file name? And if there is no such an option, and Add-In to automatically do that would be also ok I suppose…