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