Holiday Dates in Footer




This is for Access 2003. I have a query, qrySpecialDays, and I would like to
get a list of dates to print in the footer section of the report. Currently I
have a textbox in the Page Footer that is bound to the dteSpec fieldname of
the query. When I preview the report only the 1st date from the query results
is displayed. What I want displayed is as follows.

Monday, May 24, 2010
Friday, July 1, 2010
Friday, August 27, 2010

Is it possible to have a list of all dates displayed in the footer?

John Spencer

To do what you want you would need to put a SUB-Report in the footer that is
based on the qrySpecialDays. And is somehow limited to show you only the
dates you want to see.

One problem: Page footer's do not have a can grow property. The size of Page
Headers and Page Footers are a constant. Therefore you would have to size the
sub-report to fit into the size of the page footer - or size the page footer
to accept the maximum size needed for the maximum number of records returned
and displayed by the sub-report.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County


Thanks John. That worked great. I created the subreport in the footer and
sized it according to the max size of the list.


I added the following code to the footer's On Format event so that the list
of dates only prints on the 1st page.

Private Sub PageFooter2_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page Mod 2 = 0 Then
Me.PageFooter2.Visible = False
Me.PageFooter2.Visible = True
End If

End Sub

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