Control printing at a page break

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
 
M

Michel Walsh

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
 
Top