Results 1 to 4 of 4
  1. #1
    castufari is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    2

    Hiding a subreport

    I have a report with a subreport. The report contains customer data, the subreport contains invoice information. I have the report and subreport done, it's working like it's supposed to.

    What I cannot figure out is how to get the subreport under the customer info to hide if there is no data. I have can shrink/grow set to yes. The headers will show, as will an empty checkbox - and this is what I want to hide.

    How do I do this? I have No Data set to "Event Procedure", which I read would do this.

    Link shows the problem. That is false data in there but I've hidden it anyway.




  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    Is that checkbox a bound control? Even if bound do a test with it removed.

    I have a report with subreports and if no data nothing shows. However, there might still be some blank space where the subreport control is positioned.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    castufari is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    2
    Yes, it's bound to the subreport. I've removed it, which no longer shows it. But the subreport header still shows - how can I get rid of that? I might just leave it in there.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    Not sure what is happening. Would have to review the project.

    My subreports have controls in ReportHeader, GroupHeader/Footer, Detail. Nothing shows if there is no data.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Hiding toolbar?
    By BAX5127 in forum Access
    Replies: 2
    Last Post: 04-06-2011, 10:58 AM
  2. Hiding Macro
    By datacase in forum Access
    Replies: 3
    Last Post: 01-07-2011, 08:41 AM
  3. Hiding ribbon
    By jgelpi16 in forum Access
    Replies: 3
    Last Post: 12-16-2010, 11:12 AM
  4. Hiding Zeros
    By Alex Motilal in forum Reports
    Replies: 2
    Last Post: 08-06-2010, 08:28 AM
  5. hiding forms
    By Halocarbon in forum Access
    Replies: 1
    Last Post: 12-09-2005, 09:51 PM

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