Conditional Formatting for an entire record in a report 1

[psarros]

Is there a way to conditionaly format an entire recird on a report? Not just one field?


Thanks

 

[jrbarnett]

Yes - use the Detail_OnFormat event.

John

 

[LittleSmudge]

You can create the appearance of that - just by changing the background colour of the detail section depending on the value of a control in the report

Typically something like:-

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
' GetBackColour is a Function in mdlVFFunctions
Select Case txtControlNum 
    Case = 1
        Me.Detail.BackColor = 16777215
    Case = 2
        Me.Detail.BackColor = 12632256
    Case Else
        Me.Detail.BackColor = 8454143
End Select

End Sub

'ope-that-'elps





G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[LittleSmudge]

Opps - Ignore the Comment about
'GetBackColour is a Function in mdlVFFunctions

Thats just a leftover from where I poached the example from.


G