|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 28th, 2010, 05:20 AM
posted to microsoft.public.access.reports
|
|||
|
|||
Making the report footer not visible
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? 
|
|
#2
March 28th, 2010, 05:41 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Making the report footer not visible
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?
|
|
#3
March 28th, 2010, 05:11 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Making the report footer not visible
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" wrote in message ... 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?
|
|
#4
March 28th, 2010, 05:33 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Making the report footer not visible
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
