Is there an event right as a record is loaded? 1

[chiuchimuN]

I want to make format changes in a report. Rather than create query after query, It would be nice if I could deal with the printing myself. Something like:

Report_CurrentRecord(Index as integer,Cancel as integer)
if Report.Field(3)="Payed" then
Text1.Color=vbBlue
End If
if Report.Field(4)=1 then
Text2="Late Fees Applied"
else
Text2="No Late fee"
End If
End Sub

Or

Report_CurrnetRecord(Index as integer, Cancel as integer)
if Index > 4000 then
Cancel=True
End Sub

 

[AWithers]

You could make controlsource properties of text2 into an iif statement based on the above

e.g. =IIfReport.Field(4)=1 ,"Late fees apply","No Late fee&quot

then use the detail_print event to format the colour

e.g.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

If Report.Field(3)="Payed" Then
Text1.Color=vbBlue

Else
End If

Hope this helps

Andy

 

[chiuchimuN]

Does details_print trigger only once or for each record in the recordsource?

 

[AWithers]

effectively yes, for each instance of the details in the report(it will depend on the exact design of the report)

Andy