Remove blank lines

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

Guest

I have used a macro to hide certain data rows in my report; however, this
leaves a blank line where that data would have been. Is there a way to
collapse that portion of the report to eliminate the blank spaces?
 
There is probably no need for a macro or coding. Most likely the item's can
shrink property will do waht you need. You would have to tell us what you
are printing and which fields are being used.

Rick B
 
olsen9988 said:
I have used a macro to hide certain data rows in my report; however, this
leaves a blank line where that data would have been. Is there a way to
collapse that portion of the report to eliminate the blank spaces?
Click to expand...


Normally, you can use the CanShrink property to do that, BUT
why not filter that data out of the report's recordset so
you don't have to worry about it at all in the report?
 
Back
Top