If field is blank do not print

[rcima118]

Hello,

I have a form in access 2010 that prints a document rougly 500 pages in length. I want to know if there is a way to tell the form not to print a particular page if one of the fields on the page returns the word "suspended" and or the field is blank. The page has other data on it, as do they all, but if this particular field comes back null or "suspended" I would rather it just did not print that particular page in its entirety. I hope someone can help.

Cheers,
Robert

 

[John Big Booty]

Welcome to the forum.

If you do this with a Report, you could use a query to filter out records that have Null/blank fields. After all this is what Reports are designed form.

 

[deanvilar]

is there some way we can have it VBA coded?

 

[John Big Booty]

is there some way we can have it VBA coded?

What's wrong with filtering out records with Null values

 

[deanvilar]

thanks for the reply John, I already solved it ...

 

[RainLover]

What's wrong with filtering out records with Null values

John

Is this the one person with different Names.