Report Footer Problem(s)

[razorking]

Ok, While I consider myself pretty good at designing/creating reports in Access, I seem to be stuck on this. Not sure why this has never been an issue to me before, but it is killing me today.

I have a report that has disclaimer information that needs to be printed at the BOTTOM of the last page of the report. Thus I have placed a label in the report footer. Now, for some reason the label in the footer will not always stay at the very bottom of the last page - like I want. The detail section of the report will vary in size depending upon the amount of records in each order. So, if there is only one record, for example, the label on the report footer creeps up to the middle of the report. How the heck do I make it always stay at the bottom of the last page printed - regardless of how many records are in the detail section??????

 

[Brianwarnock]

If it's not too late how about something like this

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If (Me.Page = Me.Pages) Then
Me.Label1.Visible = True
Else: Me.Label1.Visible = False
End If

End Sub

Brian

 

[razorking]

And........that works...............many thanks!!

Why is there not a more obvious way in Access to do this?

 

[Brianwarnock]

And........that works...............many thanks!!

Why is there not a more obvious way in Access to do this?

I say that about a lot of things.

But as i used to say to my staff, if programming was easy we wouldn't get paid so much.

Brian

 

[tnight2060]

Similar report issues

Hi,
I think I am having similar problems to the previous question but unfortunately I do not follow the corrective instructions, as I think they are VBA.

I need to print a report with customers address, order details and then standard ending paragraphs - no problem, but I was having difficulty in getting the address to work so having read the forums I have now created a new quote/invoice report_1 to include a labels subreport. Address now looks perfect but I cannot now get the rest of the report to print with a sensible gap between the sections of the report and it continuously goes over 2/3 pages!

Can anyone help me out? I have come along and I am sure this is something really simple and help would be greatly appreciated.

I have attached a link to my database (I have removed some details to protect the innocent!).

thanks,

Theresa