Define number of line in detail section

[mett]

Hi,
Can I fixed exactly number of line in detail section on report without amount of record will print out? 'Cause some time I only have 4 records but the page designed for 8 records and when print out the footer section will pull up and I don't want that. I need help from everybody.
Thanks.

 

[jmeadows7]

Mett,

You can figure out what line you are on in the detail section with the me.linecount.

We used the following code to place a line below the last line on a page (line 23).
If Me.linecount Mod 23 = 0 Then
rpt.lastlineonpage.Visible = True
End If

Also - if your particular report never goes over 8 lines - have you thought about placing your report footer in the page footer - that way it always stays at the bottom of the page and won't be pulled up no matter how many lines are on the report?

HTH,
Jimmy

 

[mett]

Hi Jimmy,
Thanks for your advice
I followed your advice but it's not success
I created counter number in detail section with name "linecount" and in On Format even I put your syntax at that but footer still pull up went not enough 8 line.
cound your explain for more.
Thanks alot.

 

[jmeadows7]

Mett,

Before we get into too much programming on the linecount -
is your report only 1 page long?

If so, have you tried placing the report footer in the page footer?

Let me know!

Jimmy