Multi-Column Report - suppress headings

[mmogul]

I have a multi-column report (3 columns). It looks something like (goes down then across):



Product Page Product Page Product Page

aaa 1 bbb 2 ccc 3
aaa1 3 ddd 3
aaa2 1 eee 4
aaa3 4 fff 5

Some reports only have a few entries so only 1 column is used. When this happens, I want to suppress the 2nd and 3rd set of column headings.

Any thoughts on how to suppress the column headings. By the way, I am creating the headings in using the ideas in tek-tip 703-634712.

 

[dhookom]

I suppose you could change the labels for columns 2 and 3 to text boxes with control sources like:

=IIf(Count(*)>20,"Product","")
This would assume 20 products are displayed in a column.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]