Results 1 to 2 of 2
  1. #1
    fogyreef is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2015
    Posts
    3

    Show Footnote using detail when detail moves to next page

    I have a request to show/hide a footnote based on the value of a detail.

    In the report code I...

    Dim showFootnote as a global,


    set txtFootnote.visible false in PageHeaderSection_Format
    and toggle showFootnote in a detail test.

    I then set txtFootnote.visible = showFootnote in the PageFooterSection_Format.

    Works swell until a detail that would show the footnote starts on the bottom of the page but moves to the next page due to size. This apparently counts as still being in the page when the page footer format fires.

    Question: How to test only the details that wind up actually showing on the page?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    It sounds like you need to place some code in the OnFormat event. There should be several Format events, pagefooter, detail, groupFooter, etc.

    I will usually declare my variables in the header so they can be used in various events. Then I will assign the value to the variable when it is available. So you may need to assign a value to your variable when the detail section is being formatted if it is not available on Report Load.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 01-12-2016, 08:53 PM
  2. Replies: 9
    Last Post: 06-25-2014, 01:17 PM
  3. Replies: 3
    Last Post: 06-05-2014, 03:56 PM
  4. Master\Detail Only Show Last Detail Record
    By jamies in forum Queries
    Replies: 2
    Last Post: 04-14-2014, 01:25 PM
  5. Out Damn Detail, Out I Say
    By libraccess in forum Reports
    Replies: 5
    Last Post: 02-19-2013, 12:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums