[AccessD] How to suppress specific report lines while using acViewReport

Brad Marks BradM at blackforestltd.com
Thu Oct 28 15:09:10 CDT 2010


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  




More information about the AccessD mailing list