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


"DZ" <(E-Mail Removed)> wrote in message
news:3658B5EE-18F2-411E-A1F7-(E-Mail Removed)...
> 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