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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top