displaying the actual file name of the database in a report

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?
 
F

Fredsf

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.
 
F

fredg

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.
 
M

Marshall Barton

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
 
Top