Supress Printing of pages within a report

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

How do I get a report to not print pages that have a text box control source
expression that equals 0 or " "?
 
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
 
Back
Top