[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Conditionally hide detail and footer

Posted on 2007-07-31
Medium Priority
Last Modified: 2013-11-28
I have a report is grouped by employee number. In the group footer I have a sum of total hours. I would like the detail and footer to be hidden if the total hours are under 100. How do I code this.
Question by:Serena2345
1 Comment
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 19602663
How are you determining Total Hours? If this is a calculated field (i.e. you're doing this in the Report, perhaps with a Running Sum) then you may not get the results you're looking for.

You can try doing this in both the Detail and Footer's Format event;

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
  Me.Detail.Visible = Me.TotalHours<100
End Sub


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

872 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