How to Make Column Name Disappear if no values in column

  • Thread starter Thread starter doyle60
  • Start date Start date
D

doyle60

I have a sub report with a detail section for the data and a
groupheader section for the column names. What would be the code if I
want the name of the column to disappear if the column has null values
for all the records?

The Child/Master Field: PO
The Label with the Name of Column: ArticleLbl
The Field: Article
Record Source: OrderDetailsNonZeroqry

I know how to do it if I build a query first that simply returns only
those POs with a non-null article number. I could then use some code
I already have. But I want to avoid building that query.

Thanks,

Matt
 
Right-click the label, and Change To | Text Box.

Now try setting its Control Source to something like:
=IIf(Count([Article]) = 0, Null, "Whatever")

The Null values are not counted, so that should work.
 
Back
Top