Header needs to disappear

S

Shane

I have a report that has multiple headers in it and when no data is in one of
the headers it leaves a big space in the report. How do I get the header to
reduce in size if no data exist is the fields on that line? Thanks for any
help provided
 
D

Duane Hookom

Did you set all controls in the section and the section itself to Can
Shrink: Yes?
 
S

Shane

I did change that option, but the spaces are still there. I thought maybe I
would have to write code in order for the hieght to equal 0 if not data was
present, but don't know all the syntaxes. Again, any help will be greatly
appreciated
 
D

Duane Hookom

You can also use code in the On Format event of the section like:
Cancel = [Enter your true/false expression here]
 
Top