Re: Report Footer

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 09/07/04 

Date: Tue, 07 Sep 2004 18:31:43 -0500

<anonymous@discussions.microsoft.com> wrote:

>How do I display a footer only when the group has more
>than 1 record?

Add a hidden text box named txtCount to the footer and set
its expression to =Count(*)

Then the code in the footer's Format event procedure would
be:

        Cancel = Me.txtCount < 2 

-- 
Marsh
MVP [MS Access]

Relevant Pages

  • Re: Report Footer
    ... >>How do I display a footer only when the group has more ... >Add a hidden text box named txtCount to the footer and set ... >Then the code in the footer's Format event procedure would ...
    (microsoft.public.access.formscoding)
  • Re: Adding filename and path to footer
    ... into the collection of built-in footer gallery buidling blocks. ... I want to insert the filename and path into a footer. ... Greg Maxey - Word MVP ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.newusers)
  • Re: A new page problem...
    ... Thanks, MVP Herb! ... want a solution for all future documents based on that template, ... and by default the footer in Word is in Footer ... I used to love Style Sheets back in the days of Word for DOS & I ...
    (microsoft.public.word.formatting.longdocs)
  • Re: How Do I Delete Page Numbers I Dont Want!
    ... Word MVP FAQ site: http://word.mvps.org ... You should see this annoying Header and Footer ... >> I second the suggestion you made in related post to look for another ...
    (microsoft.public.word.docmanagement)
  • Re: I want to start Page 1 on the 3rd page. HOW???????? HELP????
    ... Unlink header/footer from previous--enter footer text but no page number ... Unlink header/footer from previous--enter footer text and page number. ... Left footer "master document" throughout rest of 9 pages ... Microsoft Word MVP ...
    (microsoft.public.word.pagelayout)