WillContinue Report Section Property

[Robert5833]

Has anyone used the WillContinue section property of a report? I have the
book; Access 2007 VBA, and it mentions the property and I find it available
in the VBA code library, but I can't call it up in my procedure.

I'm trying to add a text string to my report; "Continued Next Page", and/or
"Continued from Previous Page" etc., when the report page and its topic spill
to the second page. I've set the Force Page, and that works fine. I have a
few fields though that span more than one page.

I did a search on the discussion group page, but no results.

Thank you in advance...

Robert

 

[Al Campagna]

Robert,
On my website (below) in the Tips section, I have a 97 and a 2003 sample
file that shows how to display "Continued" when a detail section goes over
one page.
You only need to count detail records (DetailCount), and use this
code...

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
lblStateHeaderContinued.Visible = DetailCount > 1
End Sub

Check out my sample file/s, and you should be able to adjust it to suit
your needs... and it should work the same for and Group/s
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Chuck]

Robert,
On my website (below) in the Tips section, I have a 97 and a 2003 sample
file that shows how to display "Continued" when a detail section goes over
one page.
You only need to count detail records (DetailCount), and use this
code...

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
lblStateHeaderContinued.Visible = DetailCount > 1
End Sub

Check out my sample file/s, and you should be able to adjust it to suit
your needs... and it should work the same for and Group/s

Thank you. It works a charm. I have an old database where it was useful. I
added a comment line in the code:
'From Al Campagna: http://home.comcast.net/~cccsolutions/index.html
If I ever give it to anyone else I'll be able to give proper credit.

Chuck

 

[Robert5833]

Thank you so much; this worked out well! (Thanks too for the other cool stuff
on your site.)

I'm off and running!

Best regards,
Robert