Access Reports

[CathieB]

I have Access 2002 and have a report that has about 100 pages, I would like to put Cont'd in the Page header on all pages except for the first. I would appreciate any help in making this happen. Thank YOU

 

[smedvid]

Create a text box in the header (or footer) of report. Add following for Control Source.

=IIf([Page]>1,"Continued","&quot




Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[CathieB]

Thank you very much SMedvid. Now I would like to throw a wrench in the question. The Report has Groupings on it. Each grouping could fall on many pages, now the client wants the grouping header with Cont'd if the grouping is continued on to another page. Is that possible?

Thank you again

 

[smedvid]

I'm sure it can be done, but don't have time to psuedo code it... here are some suggestions...

Create a global/public variable (lcGroup). Within the code On Print (of footer) store the value of the Group you are printing into that variable. On header check if lcGroup is equal to Group being printed. If so, the display test "continued"...

htwh,


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...