Finding last row/detail of page

[imx]

Hi

I am currently making a line placed below a textbox disappear if the contents of the textbox is NULL. I have done this through VBA and it works fine.

I would like the line to be made visible (visible=TRUE) if the textbox of the current detail section is at the bottom (the last detail section of the current page) of the page.

This effectively means that the reoccurring lines on each page are visible if their preceding textboxes have values EXCEPT when the textbox is the last textbox of the current page, which will result in the line being made visible regardless of the textbox’s content.

If anyone has any clues on how to achieve this I would greatly appreciate any advice

Thanks

 

[JamesMcS]

Is it a form in continuous view? The line is the same object repeated over and over if that's the case, so setting it to visible means that you'll see it on every record the form is showing..... I think

 

[imx]

Its a report.
I set the line's visible property in the "Detail_format" event so I know its possible to do this through VBA.

The issue is once the whole page has been generarted, I need a way of referencing the last occuring line of that page