Hiding Data in a Report

[Stephen Hartman]

Hi,

I have a report that generates 5 columns of data, one being a price. If
this price is below 45 I would like the entire row visible. If the price is
above 45 I would like it hidden. I have tried several bits of code to no
avail. Any help would be greatly appreciated. Thanks

 

[Guest]

The easiest way I've done it is with conditional formatting. I set the font
color to white for the value I don't want displayed. This may not be the most
technical way to do it but it works.

 

[John Vinson]

Hi,

I have a report that generates 5 columns of data, one being a price. If
this price is below 45 I would like the entire row visible. If the price is
above 45 I would like it hidden. I have tried several bits of code to no
avail. Any help would be greatly appreciated. Thanks

Why not simply base the report on a Query with a criterion

= 45

on the price field? Then the rows with prices under 45 would simply
not be there to show at all.

John W. Vinson[MVP]