Using VBA to hide a report's detail section?

[Paul Kraemer]

Hi,
I am using Access 2007. I have created a report with a detail section and
some summary information in the group header. Sometimes I want to see the
detail section, but other times I would like the detail section to be hidden
so that I only get the summary info. Can anyone tell me if there is a
relatively easy way I can give myself this choice each time I run the report
using VBA? If so, if you could give me a quick sample of how to reference a
report's detail section and tell me what is the best event to use if I want
to set the .Visible property to False, I'd really appreciate it.

Or is it easiest to just create two reports, one with the Detail section
visible and one with the detail section not visible?

Thanks in advance,
Paul

 

[Duane Hookom]

Don't create multiple reports. You should have a form with a command button
that opens the report. Add a check box to the form "chkHideDetails". Then add
code to the On Format event of the detail section of the report:

Cancel = Forms!frmYourNameHere!chkHideDetails

--
Duane Hookom
Microsoft Access MVP

NOTE: These public News Groups are ending June 1st. Consider asking
questions at http://social.answers.microsoft.com/Forums/en-US/addbuz/threads?