Dont force a Blank Page if Field is Null !!!!!! Please Help

[TheNovice]

Hello again,

Asking for some expert advise. I have a report that has two sections both
with headers and footers. in the final footer I have a unbound field that if
the check box is true show the field, if false, Null. it wiorks great, but
here is my problem. that footer need to pring on the second page and it will
if I "Force New Page" but if it is null it gives me a Blank page. I tried
the grouping and Page Breaks and Footer Properties but they all seem to do
the same thing or it doesnt.

Please help!!!!

 

[Marshall Barton]

Asking for some expert advise. I have a report that has two sections both
with headers and footers. in the final footer I have a unbound field that if
the check box is true show the field, if false, Null. it wiorks great, but
here is my problem. that footer need to pring on the second page and it will
if I "Force New Page" but if it is null it gives me a Blank page. I tried
the grouping and Page Breaks and Footer Properties but they all seem to do
the same thing or it doesnt.

Try cancelling the footer's Format event when the check box
is not checked:

Cancel = (Me.thecheckbox = False)