Access 2007 - Displaying current Filename

  • Thread starter Thread starter kschuster
  • Start date Start date
K

kschuster

Just converted to 2007. I can be running multiple databases at any given
time. How do I get the name of the database to display in the work area -
status bar - menu bar...?

Very frustrated by this
 
In Access 2007, the database name displays in the application title bar if
you have nothing else specified to show there under:
Office Button | Access Options | Current Database | Application Options

If you want to programmatically show it on a form, use a text box with
Control Source of either:
=CurrentProject.FullName
=CurrentProject.Name
(depending on whether you want the path shown), or:
=Currentdb.Name

You can show it in the Status Bar with this code:
Call SysCmd(acSysCmdSetStatus, CurrentProject.FullName)
But it will be lost next status message, of course.
 
Usually the file name displays in the Access window title, at the top of the
Access window. If you've assigned an Application Title (Access Options,
Current Database) then that displays as the window title.
 
Back
Top