reading the previous record in a report.

[diwin]

Can you apply conditional formatting on one field in a report based on the value of a field in the previous record?

Daniel Dillon
O o . (<--- brain shrinking at rate shown.)

 

[Remou]

You can do something like:

Option Explicit

Dim LastValue As String

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If LastValue = "S" Then
    Me.Surname.BackColor = vbRed
Else
    Me.Surname.BackColor = vbWhite
End If

'& "" in case of nulls

LastValue = Me.Surname & ""

End Sub

http://lessthandot.com