Space appears between header and details

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a space between the header and the details and I cannot figure out how
to remove it. There is no space in design view. I have tried removing the
last row of labels from the header and moving the details bar upwards and the
space is still there. The details have lines round them so if it was blank
records at least the empty fields would show but this is not the case.

Any ideas?

Ali
 
No. In the design view there is no space at all between the controls on the
hdr and the controls in the details. I have also copied this report to
create another and the same thing is happening.

It's got to be some little thing that I am over looking. But I am out of
ideas.
 
Do you have any code on the report open properties that might extand the
hight of the section
 
Thanks Ofer, but I already tried that - no luck. It's also not blank records.

I can't think what it might be.
 
In the detail section, change to the "Can grow", "Can Shrink" properties of
the section and the fields in the section to yes, and try.
It could be that you have blank records in the table, and they apear in the
beggining
 
I have found the problem. In the header is an address which includes lines
which can shrink. If all the fields in a line are empty the fields do not
show but then the blank space appears at the end of header. When these
fields contain data the header joins the details as required.

Any ideas on how to fix this?

Your help is appreciated.
 
Because the Header section doesn't have "can shrink" properties, I would add
some code to play with the hight of the section depend on the value

On the On format property of the Header you can write the code

If isnull(me.FieldName) then
me.Sectionname.Hight = 3
Else
me.Sectionname.Hight = 5
End if

Play with hight to suit you need
 
Back
Top