displaying the actual file name of the database in a report

  • Thread starter Thread starter Octavee Uhl
  • Start date Start date
O

Octavee Uhl

Is it possible to display the actual file name of the
database in a report automatically, like in excel etc? If
yes, how does that works?
 
Try this (text box):
=Left([CurrentProject].[Name],Len([CurrentProject].[Name])-
4)

I do not remember the source of the above code. But
someone else did figure it out.

I am looking for a way to display the actual report name
on the report.
 
Is it possible to display the actual file name of the
database in a report automatically, like in excel etc? If
yes, how does that works?
Click to expand...

=[CurrentDb].[Name]

You can use the Right, Left, Mid and InStr() functions to separate out
that portion of the name or path not needed.
 
Octavee said:
Is it possible to display the actual file name of the
database in a report automatically, like in excel etc? If
yes, how does that works?
Click to expand...

You can use a text box with an expression:

=CurrentDb().Name
 
Back
Top