Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding Report Headers (access 97)

    Could someone please explain to me how i may hide a part of a report when the contents of that section meet certain criteria please ?
    I have three fields returned from from a query and the sum of two of these , minus the other field produces a value. Whether this value is positive or negative controls whether a fourth control shows one value or another. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    I need only show a header where three of the same value occur consecutively in the fourth control.

    Where do i put the code ? What code do i need?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hiding Report Headers (access 97)

    Put the code to test the values in the Format event of the section. All you need to supress the section is this:

    PrintSection = False
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Report Headers (access 97)

    Thanks very much, this is very close.
    I have put the test in two places as i need to blank out two headers if the test is true.
    The report is only showing the records that i want it to now but , there are gaps where the other records were previously displayed. How do i get the report to shuffle it all forwards ?
    I have looked at MoveLayout and NextRecord but the default for these is true and should therefore skip to the next appropriate record, unless i have misunderstood the online help.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hiding Report Headers (access 97)

    You want to set MoveLayout to false. That prints the next section in the current position instead of leaving space for the header that isn't being printed.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Report Headers (access 97)

    Perfect, thank you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •