Control printing at a page break

  • Thread starter Thread starter DZ
  • Start date Start date
D

DZ

Hi

My report has 3 pages for each record, separated by page breaks. How can I
not print the area after the 2nd page break (page 3) if the value in a field
is null.

Thanks

I will credit any helpful responses

DZ
 
Something like:


If ( IsNull( value ) AND [page] >=3) then

MoveLayout=false
PrintSection = false

else

MoveLayout=true
PrintSection = true

end if


(in the Detail_Print event handling subroutine)



will not print the row if the tested value is null (PrintSection=false)
without leaving a blank line (MoveLayout=false).



Vanderghast, Access MVP
 
Back
Top