Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
add header and footer to page for printing
- Thread starter womblies
- Start date
Hi, Maybe this will help,
Place a label into the header and footer and leave them blank, then before you show or print the page, populate the label with a line like:
ReportName.Sections(1).Controls("Label1"
.Caption = "This is the Title"
Where ReportName = the name you have for your report
Sections(1) = the first section on the report
Label1 = the label name on the report
Hope this is what you need...
Place a label into the header and footer and leave them blank, then before you show or print the page, populate the label with a line like:
ReportName.Sections(1).Controls("Label1"
.Caption = "This is the Title"Where ReportName = the name you have for your report
Sections(1) = the first section on the report
Label1 = the label name on the report
Hope this is what you need...
- Status
Similar threads
- Locked
- Question
