Print Name of Report

[rstitzel]

Is there a way to print the name (i.e. rpt_Sales_2000) of the report ON the report? I don't want to have to go into each report and create a text box with the name of the report. I want it to be dynamic in case I decide to change the name of a report.

Any and all help is appreciated.

Thank you.

 

[dhookom]

Try a text box with a control source of:
=[Name]
This displays one of the reasons to never name a field "name".

Duane
MS Access MVP

 

[rstitzel]

Thanks Dhookom BUT This is a database that was developed by my boss and he did create a field named "name" that is used in the report. Now what? If I rename the field will Access rename it throughout the entire database -or- will I have to go into every query, form etc and change it manually.

Thanks

 

[dhookom]

If you have problems with the name "name" then I suggest you invest in one of the applications that search and replace in MDB files. There are a couple programs referenced at

http://www.mvps.org/access/resources/products.htm.

YOu can alias the Name field in your report's record source:
CompanyName: Name
THis will fix this one report if you have issues.

Duane
MS Access MVP