Print Report footer at the bottom of the page

[lmontes]

Hello

Is there a way to print the report footer at the bottom of the page?

 

[tyrdrannoy]

add a text box to the page footer section and set the control source:

="Page " & [Page] & " of " & [Pages]

 

[lmontes]

That didn't work. I have a page footer with the page numbers already. That still prints at the bottom. When I added the textbox to the report footer, it printed right after the last record (in the middle of the page).

Thanks

 

[tyrdrannoy]

oh, sorry, i misunderstood. anything you want to print at the bottom of the page has to be in the page footer. report footer will always show up after the last record, as far as i know. i've been working with access reports for 4 years, now.

possibly you could add code to the report footer's on format event:

if me.[page].value = me.[pages].value then
hiddenTextbox.visible = true
hiddenTextbox.value = "whatever text you want here."
end if


and set the hidden textbox's canShrink value = true

 

[lmontes]

Thanks anyway!