Supress Printing of pages within a report

K

Kim

How do I get a report to not print pages that have a text box control source
expression that equals 0 or " "?
 
M

Michel Walsh

Base your report on a query rather than directly from a table, and have that
query removes those records you don't want:

SELECT *
FROM myTable
WHERE someField <> 0 AND 0 <> len(Trim(someField & "" ) )


Sure, if you really want to supress the WHOLE page containing multiple
records as soon as ONE of the record has the expression equals to 0, as
example, that won't work, since the proposed solution removes ONLY the rows
having the said behavior.


Vanderghast, Access MVP
 
Top