Text in footer

  • Thread starter Thread starter programmingrookie
  • Start date Start date
P

programmingrookie

I have a report with page breaks between departments, and the department name
is kept in a text box. I want to add a text box to the page footer that also
displays the department name that appears on that page. When I try to use
the same control source, the names appear but not in the correct order. For
instance, if Dept. A appears over two pages, the name "Dept. A" appears on
the first page, but "Dept. B" appears on second page, etc.

I also tried to set the control source of the footer text box to equal the
value of the department name on the current page.

me.footertxtbox = me.departmentname

This also does not work. In fact, the footer textbox does not appear on the
report at all.
 
I would try place a text box in the detail section:
Name: txtDeptName
Control Source: [DepartmentNameField]
Then add a text box to the Page Footer:
Control Source: =txtDeptName
 
Back
Top