Changing Summary Options

R

Rhys'''' Pieces

I created a report in Access 2003 using the Report Wizard. In summary options
I chose Detail & Summary. Can I change it to Summary only now that it has
been saved? How? Thank you for the advice.
 
D

Duane Hookom

Sure, you can set the detail section to invisible. If you want the users to
"toggle" this, you can add code to your report like:

Option Compare Database
Option Explicit
Dim booHideDetail As Boolean

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Cancel = booHideDetail
End Sub

Private Sub Report_Open(Cancel As Integer)
If MsgBox("Do you want to display details?", _
vbQuestion + vbYesNo, "Show Details") = vbYes Then
booHideDetail = False
Else
booHideDetail = True
End If
End Sub
 
Top