>I have placed the label 'continued...' in the Page Footer. Of course, it's erroneous to print this on the last page of the report.
>
>I have been trying to come up with something in the Print When... that will fix this. One thing I tried was Print When... RECNO()+1<>EOF(). Alas, this is an Operator/Operand type mismatch.
>
>Would greatly appreciate help. TIA, CH.
The reason RECNO()+1 <> EOF() doesn't work is because RECNO()+1 is numeric and EOF() is logical. Using similar logic, you could say RECNO() <> RECCOUNT(), but this wouldn't work in cases where the last record is deleted and doesn't print, or if you have a filter or scope clause.
Here's an idea. Before you call the report, store the record number of the last record you know will print. Then you can test if RECNO() <>
in the footer.