Extra Spacing at the Bottom of a Report

[cnodadmo]

I have a sub-report and the last row is highlight, however, there seems to be extra spacing after the last row. I removed all report/page header/footer so all what's left is the Detail section but I still have this white space after the last row. Does anybody know what could be causing this white row? I've attached an image of my report.

 

[Mihail]

Try to decrease the height for the subreport control in the main report.

 

[cnodadmo]

Try to decrease the height for the subreport control in the main report.

i've tried where the height was less than 0.05 and that bottom section was still showing up :banghead:

 

[Mihail]

If you can upload the database.... (Access 2007)

 

[cnodadmo]

If you can upload the database.... (Access 2007)

Hi Mihail, I've created a Test database since the current one uses an ODBC connection. Anyway the input box when it pops up when you run the report is "Test". Thanks for looking into this.

 

[Mihail]

Not very elegant but work.
Set the Can Grow property for the subreport control to No then adjust the height for the control until fit your needs. Hope that the number of rows is static (constant). If not, you are still in trouble.

From what I see, in Print Preview all seems to be OK (is not affected by Can Grow property). Also when print the report on the paper (I have printed in One Note).

Unfortunately I can't say why you have that extra space (seems to be equal, as height, with one row).