Do not want to print line????

[basbrian]

I am trying to do a validation report. My query reads all the records, then in the detail line format area, I use sql to retrieve some addition information before calculating some variance fields. If the variance fields are less than a set figure, I do not want to print this line.
Is there any way I can do this ???

 

[Crowley16]

can't you calculate the variance, and then bound the line to the results with a where condition?

if you can't, then you'd have to individually test the variance values and then set the height of the controls manually...

 

[glalsop]

If the variance fields are displayed in the detail section, you can cancel the Detail_Format event based on their values:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Me.Variance1 < 5 Then
Cancel = True
End If

End Sub


-Gary

 

[basbrian]

thanks Gary works great