First Published 30 Dec 2024

This article was prompted by a thread by @misionero at Access World Forums: Subform. Format property. Show header and footer. No difference in putting YES or NO

Like reports, forms can have a page header and page footer section as well as the much more widely used form header and form footer sections.


However, the page header/footer sections are rarely useful, as in normal use, forms do not have pages. As a result, those sections are not seen in form view (or layout view):


The only time these sections will appear is if the form is displayed in print preview (or printed). In other words, if the form is used as a report.


The forum poster seemed unclear of the purpose of these sections. To make matters more complicated, he/she was using the form as a subform.
The issue was that the subform property sheet includes a property 'Show Page Header and Page Footer' with possible values Yes/No.


The property (and its value) has absolutely no purpose in a subform as the page header / footer sections are not shown even when printed.


As already stated, the page header / page footer sections are widely used in reports which are designed to be printed.
The 'Show Page Header and Page Footer' property is also available for subreports:


For subreports, setting the property to Yes shows the subreport page header / footer. Setting the property to No, hides those sections.



It is also possible to use a form as a subreport or a report as a subform. When this is done, each behaves just as it would in 'normal use'.

This means that when a form is used as a subreport, the page header / footer sections are NEVER seen.


However, when a report is used as a subform, the page header / footer sections can be displayed or hidden depending on the property sheet value.


In the screenshot above, the page header is visible. The page footer isn't shown in this example as the height of the subreport is too tall for the available space.



Download

Click to download the example app used in this article:       FormPageHeaderFooter     ACCDB file (0.8 MB zipped)



Feedback

Please use the contact form below to let me know whether you found this article interesting/useful or if you have any questions/comments.

Please also consider making a donation towards the costs of maintaining this website. Thank you



Colin Riddington           Mendip Data Systems                 First Published 30 Dec 2024

Return to Access Blog Page

Return to Top