How to know the last record at the Detail_Format event

I have changed the code. The line position in the first page is right but
for the next pages, the line position is wrong.
Thanks.

"Marshall Barton" wrote in message
...
Thank you for diagnosing my typo. I could have looked at it
forever without seeing it. Change that line to:

Me.txtBottom = Me.Top + Me.Height - MARGIN

I'm still concerned about what to do when a detail is split
across a page boundary.
--
Marsh
MVP [MS Access]


Vensia wrote:
At the detail section, there are several text boxes and 2 subreports.
The subreports can grow to several pages.
I have check Me.Section(0).Height at Detail_Print and find the height of
detail section is not changed although the subreport grow to several
pages.
That's why the below code doesn't take effect.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.txtBottom = Me.Top + Me.Section(0).Height - MARGIN
End Sub


Vensia wrote:
I'm talking about the detail section of main report.
I put all of your code in the main report.
The main report has a subreport (can grow) at its detail section.
There is only one record in the detail of main report.
So I find that the height of detail section is fixed when the report
is
running.

Could you be more specific about how the position is wromg?

Are you sure the line Me.txtBottom = . . . is in the detail
section's Print event?

Please post the relevant code as it is now.
--
Marsh
MVP [MS Access]


Vensia wrote:
I have changed the code. The line position in the first page is right but
for the next pages, the line position is wrong.


"Marshall Barton" wrote
Thank you for diagnosing my typo. I could have looked at it
forever without seeing it. Change that line to:

Me.txtBottom = Me.Top + Me.Height - MARGIN

I'm still concerned about what to do when a detail is split
across a page boundary.


Vensia wrote:
At the detail section, there are several text boxes and 2 subreports.
The subreports can grow to several pages.
I have check Me.Section(0).Height at Detail_Print and find the height of
detail section is not changed although the subreport grow to several
pages.
That's why the below code doesn't take effect.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.txtBottom = Me.Top + Me.Section(0).Height - MARGIN
End Sub


Vensia wrote:
I'm talking about the detail section of main report.
I put all of your code in the main report.
The main report has a subreport (can grow) at its detail section.
There is only one record in the detail of main report.
So I find that the height of detail section is fixed when the report
is
running.

"Vensia" wrote

Actually I want to add a horizontal line after the last record for every
page except the last page.

How about just putting a line at the very top of the Page Footer. If you
don't use a Page Footer, make one just for your line. You can set a Report
level variable in the Report Footer, sense it in the Page Footer, and make
the line invisible if you don't want one on the very last page.

That will put a horizontal line after the last record on the page.

Larry Linson
Microsoft Access MVP

I have checked and the line code is in the detail section's Print event.
The line in the first page is at the right position, in the second page, the
line is at the above, and in the third pages, the line is not seemed.

"Marshall Barton" wrote in message
...
Could you be more specific about how the position is wromg?

Are you sure the line Me.txtBottom = . . . is in the detail
section's Print event?

Please post the relevant code as it is now.
--
Marsh
MVP [MS Access]


Vensia wrote:
I have changed the code. The line position in the first page is right but
for the next pages, the line position is wrong.


"Marshall Barton" wrote
Thank you for diagnosing my typo. I could have looked at it
forever without seeing it. Change that line to:

Me.txtBottom = Me.Top + Me.Height - MARGIN

I'm still concerned about what to do when a detail is split
across a page boundary.


Vensia wrote:
At the detail section, there are several text boxes and 2 subreports.
The subreports can grow to several pages.
I have check Me.Section(0).Height at Detail_Print and find the height
of
detail section is not changed although the subreport grow to several
pages.
That's why the below code doesn't take effect.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.txtBottom = Me.Top + Me.Section(0).Height - MARGIN
End Sub


Vensia wrote:
I'm talking about the detail section of main report.
I put all of your code in the main report.
The main report has a subreport (can grow) at its detail section.
There is only one record in the detail of main report.
So I find that the height of detail section is fixed when the
report
is
running.

I'm afarid that I do not understand what you are saying.

I need to verify the code that you are actually using.
Please post a Copy/Paste of both event procedures as you now
have them.

I don't understand what you mean by "in the second page, the
line is at the above, and in the third pages, the line is
not seemed". Please provide more specific information about
where the line is actually appearing.

I also need to know what you want to happen if the main
report detail is entirely on the same page as the line or if
the detail is split across multiple pages.

As Larry asked elsewhere in this thread, why not put the
line in the page footer section instead of all this fooling
around???
--
Marsh
MVP [MS Access]


Vensia wrote:
I have checked and the line code is in the detail section's Print event.
The line in the first page is at the right position, in the second page, the
line is at the above, and in the third pages, the line is not seemed.

"Marshall Barton" wrote
Could you be more specific about how the position is wromg?

Are you sure the line Me.txtBottom = . . . is in the detail
section's Print event?

Please post the relevant code as it is now.


Vensia wrote:
I have changed the code. The line position in the first page is right but
for the next pages, the line position is wrong.


"Marshall Barton" wrote
Thank you for diagnosing my typo. I could have looked at it
forever without seeing it. Change that line to:

Me.txtBottom = Me.Top + Me.Height - MARGIN

I'm still concerned about what to do when a detail is split
across a page boundary.


Vensia wrote:
At the detail section, there are several text boxes and 2 subreports.
The subreports can grow to several pages.
I have check Me.Section(0).Height at Detail_Print and find the height
of
detail section is not changed although the subreport grow to several
pages.
That's why the below code doesn't take effect.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.txtBottom = Me.Top + Me.Section(0).Height - MARGIN
End Sub


Vensia wrote:
I'm talking about the detail section of main report.
I put all of your code in the main report.
The main report has a subreport (can grow) at its detail section.
There is only one record in the detail of main report.
So I find that the height of detail section is fixed when the
report is running.