Report Printing with Conditions

123dstreet

Registered User.
Local time
Yesterday, 16:48
Joined
Apr 14, 2010
Messages
122
Hi All,

I am trying to add a code to my report to NOT print a text box if a certain condition is met. It is the last text box in the report footer, and it takes up basically the entire page, I have tried using the:

If form!combo122="Sales Order" then
Textbox300.visible=false
end if

the only problem is that even though it doesn't appear on the report when I print, the printer still shoots out that last page(blank). Any idea's on how to fix this so I'm not wasting paper everytime I print this report?

Thanks!!!
 
I have it on Load. It makes it not visible, but the last page still prints out as if its there, but it prints a blank page.
 
I just tried that, it seems to do the same thing, it's definitely not showing up on the report, but still printing a blank 2nd page.
 
Would there be a code that, if a condition is met, then only print page 1 of the report??
 

Users who are viewing this thread

Back
Top Bottom