Prev: visible label based on text value
Next: How to format a portion of a text box in bold letters
From: KM on 28 Mar 2010 00:20
My objective is to use VB to hide the footer in a report. I am using the
following:
Reports("" & ReportName & "").Section(ReportFooter).Visible = False
where Reportname is just that.

However it hides the details section.
How does one hide the footer?
From: KM on 28 Mar 2010 00:41
Just found a soluton that works. But is there a btter way?
Reports("" & ReportName & "").Section(2).Visible = False


"KM" wrote:

> My objective is to use VB to hide the footer in a report. I am using the
> following:
> Reports("" & ReportName & "").Section(ReportFooter).Visible = False
> where Reportname is just that.
>
> However it hides the details section.
> How does one hide the footer?
From: Duane Hookom on 28 Mar 2010 12:11
I would use code in the On Format event of the Report Footer Section. You
never told us how the visibility is determined or how the report is opened.
Try code like:

Cancel = (Forms!frmRptOpen!chkHideFooter = True)

--
Duane Hookom
MS Access MVP


"KM" <KM(a)discussions.microsoft.com> wrote in message
news:264A34CE-6358-47CD-ACF6-47636983E21A(a)microsoft.com...
> My objective is to use VB to hide the footer in a report. I am using the
> following:
> Reports("" & ReportName & "").Section(ReportFooter).Visible = False
> where Reportname is just that.
>
> However it hides the details section.
> How does one hide the footer?

From: John Spencer on 28 Mar 2010 12:33
You can use the acReportFooter (which is equal to 2)

The section constants that are available are

Value Constant Description
0 acDetail Form detail section or report detail section
1 acHeader Form or report header section
2 acFooter Form or report footer section
3 acPageHeader Form or report page header section
4 acPageFooter Form or report page footer section
5 acGroupLevel1Header Group-level 1 header section (reports only)
6 acGroupLevel1Footer Group-level 1 footer section (reports only)
7 acGroupLevel2Header Group-level 2 header section (reports only)
8 acGroupLevel2Footer Group-level 2 footer section (reports only)


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

KM wrote:
> Just found a soluton that works. But is there a btter way?
> Reports("" & ReportName & "").Section(2).Visible = False
>
>
> "KM" wrote:
>
>> My objective is to use VB to hide the footer in a report. I am using the
>> following:
>> Reports("" & ReportName & "").Section(ReportFooter).Visible = False
>> where Reportname is just that.
>>
>> However it hides the details section.
>> How does one hide the footer?
 | 
Pages: 1
Prev: visible label based on text value
Next: How to format a portion of a text box in bold letters