Changing content of label in code (report_page)

[arboral1]

I have a report that contains 20 record per page. When i'm trying to print a report that contains 40 record, i can't get the content of the label to change (alltought the number of pages equals 3, i force it by checking page -1.
When i debug the code and check the content of the label in immediate it has the right value but when previewing and printing it does not..can someone help me out?

code:
Private Sub Report_page()
If totpaginas = 1 Or Report.Page = totpaginas - 1 Then
Report.Controls("tit1").Caption = "Totaal"
Else
Report.Controls("tit1").Caption = "Overdracht"
End If
end sub

 

[scriverb]

Try putting the above code in the OnFormat of the Detail Section. It is here that I usually make specific controls and/or labels visible and invisible.

Post back if you need more discussion.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]