Re: How to know the last record at the Detail_Format event

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Actually I want to add a horizontal line after the last record for every
page except the last page.
Is there any idea ?

Vensia

"Marshall Barton" <marshbarton@xxxxxxxxxx> wrote in message
news:gap5n1t8cdunoog55l6umrt7oqmuqb78d9@xxxxxxxxxx
> Vensia wrote:
> >At the Detail_Format event, can I know the last record of each page ?
> >After the last record, I want to add something.
>
>
> The page huh? That's a tricky one that I don't think can be
> done in the general case.
>
> If you detail section can not grow or shrink, then it's not
> too bad. The last detail will be the one where the Report's
> Top property is a fixed position on the page. E.g
>
> If Me.Top > 8*1440 Then
> 'do your thing
> End If
>
> The 8 above is the number of inches from the top of the page
> where there is only enough room for one more detail.
>
> Note that CanGrow and KeepTogether can cause the Format
> event to be fired before it is determined that the section
> won't fit on the current page.
> --
> Marsh
> MVP [MS Access]


.