Last Record in a Report

dlamarche · May 4th, 2009, 01:16 AM

Hello,

Anyone knows a way to find out when Access prints the last record in a report? There is a thing I want to do for each record (in the Detail section) but not when the last report in printed. Not the Page footer or the Report footer I am talking about the last record in the acDetail section.

I do program some reports occasionally and it is easy to find out in a form but in a report I am stuck. Thanks.

SerranoG · May 6th, 2009, 04:53 PM

Place a hidden textbox in the detail section. Call it, say, txtItemNo. In its control source, place the formula

=1

In its properties, set Running Sum = Over All.

In the detail section's On Format Event place this IF statement.

Code:

If Me.txtItemNo = DCount("[Primary Key Here]", "Report's Record Source Here") Then
    'Last Record.  Do this.
Else
    'Not the last record.  Do that.
End If

Replace "Primary Key Here" and "Report's Record Source Here" with their actual values. Also replace my comments with actual code.

dlamarche · May 7th, 2009, 08:56 AM

Thanks SerranoG

Yep that would do the job all right. Thanks a bunch that is very clever.

Appreciated.