max post on page - 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

BACKGROUND:
I would like to take the last post of the page from PageFoot to PageHead,
butI got two answer by using Arry and other was by DLookup.
But both Not work exact after few page, because few Field on Detail have
option with “CAN GROWâ€
And when I change it, then it work, but I need it with Can Grow. And when I
asked so there was no one answer for this question.
Here is the sample if you are interested to check it:
http://w5.nuinternet.com/s650100026/first-word.zip


Any way, Now I am thinking if I can calculate how many posts on the current
detail page is and then minus 2 posts then make PageBreck. Maybe it will work
for above question.

So I created TextBox with name: Counter
and wrote on score : =1
and choose on Running Sum: Over All

So what I have to wrote here ?
-----------
If Me![Counter] Mod ??????? = 0 Then Me![PageBreak].Visible = True _
Else Me![PageBreak].Visible = False
------------

I need that looks like:
Max count posts on current page - 2 post Then PageBreck.

Which I mean that every page missing two post to be full.

How can this ide looks ?

Thank you for reading my question
 
Hello

I forget to tell you that the report have two columns

I think it showld look something like this:

If report have 2 columns Then

If Me![Counter] Mod ??????? = 0 Then Me![PageBreak].Visible = True _
Else Me![PageBreak].Visible = False

End If

What is your opintion ?

Thanks
 
Hi

I am not sure if the code be like:

If "posts have now reached columns 2" Then

If total posts on current page Then
total posts on current page = total posts on current page - 2 post
Me![PageBreak].Visible = True
Else Me![PageBreak].Visible = False

End If

Thanks
 
Back
Top