Automatic Filename on a Report

[JasonTruman]

Hi all

How can I put the database filename into the Report Header of a report. I know there are things like Application.CurrentProject.Name etc that has to be incoprorated into some VBA code, but where does this code go?

I assume you create a text box in the report header, but what Event am I changing? Report events, text box control events ??

Any assistance will be greatly appreciated especially the relevant code

Cheers

Jason

 

[petejm]

Hi,

Create a text box in the report header.

Right click on the text box and select properties.

Click on the Data tab.

In the Control Source box type: =CurrentProject.Name

Close the properties window and preview the reprot.

You should see the database name.


hope this helps

Regards

Pete

 

[JasonTruman]

Don't u hate it when it's so simple

I've just tried =CurrentProject.FullName and I got the path too

Cheers Pete

 

[petejm]

Your welcome.

And thanks for the full name. Did not know that.

Pete