[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

MS Access Report

I would like to hide the detail section of the report. Is there any VBA that I can use? I want to keep the header and totals on the report footer. thanks
0
snhandle
Asked:
snhandle
2 Solutions
 
Jack LeachProprietorCommented:
I guess you could set the detail height to 0 (and any controls also), but... why not run a query that gets you the same values as the footer would display, and use those in the detail instead?
0
 
Kelvin SparksCommented:
Look for the report On Format event and try
Me.Detail.Visible=False

Kelvin
0
 
snhandleAuthor Commented:
Good
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Besides just setting the property to false at design time, you can set the detail's visible property on the fly too...I do this often when I want to give a user a choice between a summary and detail report (like a G/L Trial Balance).

Jim.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now