Using VBA to print report names on all reports in an Access DB

G

Guest

Hello, I have an Access 2003 .mdb database that over 150 reports in it. I'd
like to be able to use VBA or some other method to print the report name on
any given report report when printed. I did this before by using a label
control and VBA in the Open event for the report to get the report name on
the report, but that method takes too long. Any suggestions would be greatly
appreciated.
 
F

fredg

Hello, I have an Access 2003 .mdb database that over 150 reports in it. I'd
like to be able to use VBA or some other method to print the report name on
any given report report when printed. I did this before by using a label
control and VBA in the Open event for the report to get the report name on
the report, but that method takes too long. Any suggestions would be greatly
appreciated.
Click to expand...

Add an unbound text control to the report.
Set it's control source to:
=[Name]
Make sure the name of this control is NOT "Name".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Control Page Setup of a Report through Coding 5
Report Will No Print In Color 1
Change printer to print report 3
Can't get this code to work properly to print 1
Appending mutiple reports to PDF using VBA. 4
EMailing a report in Access 2003 3
Prevent unwanted report printing via VBA 1
Access Access Report Works on One Machine but not Another 3

Top