Prev: bread association between label and text box
Next: Subtotals
From: Paul Kraemer on 24 May 2010 16:02
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
--
Paul Kraemer
From: Duane Hookom on 24 May 2010 17:00
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?


"Paul Kraemer" wrote:

> 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
> --
> Paul Kraemer
 | 
Pages: 1
Prev: bread association between label and text box
Next: Subtotals