Why use Form Headers and Footers?  Seems like you can do the same on the body of the form

Posted on 2011-10-13
Last Modified: 2012-05-12
Why use the form headers and footers.  You can enter any data pertinent to data input right on the entry screen where fields are located.  Or am I missing something.
Question by:brothertruffle880
    LVL 8

    Accepted Solution

    LVL 119

    Assisted Solution

    by:Rey Obrero
    the form headers and footers can be used to hide/unhide controls in one command line ( this is just one of the simple usage)

    if you don't need them, just don't use them
    LVL 47

    Assisted Solution

    by:Dale Fye (Access MVP)
    They are great for controls which are not bound to the current record, or for continuous forms.

    I generally put search and filter controls and buttons for a wide variety of actions in the forms header.

    I use the footer for custom navigation buttons, Save, Cancel, Close buttons and in continuous forms to display sums or counts of numeric fields in the continuous portion of the form.
    LVL 26

    Assisted Solution

    Ditto what @fyed said.
    Construction of data entry forms is a bit of an art form
    <You can enter any data pertinent to data input right on the entry screen where fields are located>

    I don't permit that.  Editing, yes -- Entry, no.
    That way I can control when new records get created, and ensure that the data is all valid.
    I do that through unbound controls and a command button in the form header
    The form detail is where the continuous mass of editable records gets displayed.

    Simple forms don't generally use the header/footer much.
    Go ahead and use the form wizard to create a tabular (continuous) form
    All the column labels go in the header.

    Most folks don't use datasheet forms.
    It's too easy for the end-users to hose the data up accidentally
    LVL 56

    Assisted Solution

    by:Jim Dettman (Microsoft MVP/ EE MVE)

      The main reason for placing controls in a header or footer is that they won't scroll off.

    LVL 14

    Assisted Solution

    by:Bill Ross

    If you place a button like "Exit" for example a the bottom of the form footer it will always be in the same place.  This is especially useful for continuopus forms.  You can also accent the data by setting the detail background to one color and the form header/footer to another.

    LVL 74

    Assisted Solution

    by:Jeffrey Coachman
    Not much to add to what the other great experts posted here.

    But a little history may be in order.

    Reports and Forms evolved concurrently so some things that are more useful in reports ended up in Forms and vice versa.

    With every new version of Access the line between Forms and Reports get blurred a little more...

    For example, in Access versions previous to 2007, reports had no "Interaction".
    Now they do have a bit: ...In Report view you can Filter, click buttons and activate hyperlinks

    LVL 26

    Assisted Solution

    Ditto what @boag2000 said.

    You shouldn't print forms.  Others do disagree with my doctrinairie stance on that.
    I insist that reports are for printing, not forms.  Nevertheless...
    If you print a form, the form header and footer behave like the report header and footer do--Printing once at the very beginning (header) and once at the very end (footer)
    You can also turn on a page header and footer for forms.
    They do not have the same events that reports sections do, however.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now