[AccessD] How to suppress specific report lines while usingacViewReport

Rocky Smolin rockysmolin at bchacc.com
Thu Oct 28 15:30:44 CDT 2010


Brad:

I use the Format event of the Detail section all the time to do this.
Preview or Print  shouldn't matter.  

I use:

If Nz(Me.fldMWCIInventoryQuantity) = 0 And Nz(Me.Allocation) = 0 Then
    Me.MoveLayout = False
    Me.NextRecord = True
    Me.PrintSection = False
End If

Sub in your own conditions on the If. This was cribbed directly from the
Detail_Format event module.  But it works in the Format event of any
section.

HTH

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, October 28, 2010 1:09 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to suppress specific report lines while
usingacViewReport

We are using this command to open a Report DoCmd.OpenReport "Report100",
acViewReport, "", "", acNormal

I would like to suppress some detail lines and subtotals based on the value
of another field.  

The "On Format" event apparently does not get initiated with acViewReport

The "On Paint" event does get initiated and can detect the conditions when
we would like to suppress a line by looking at the value of a field. 

The catch is that when I try to use

Me.ABC.Visible = False

I receive the following
Error 32521 - You can't change the value of this property in the OnPaint
event 

There is probably an easy way to do this.  I must be missing something.

Thanks,
Brad  

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list