Eliminating blank fields in a report

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

Guest

I created a report that covers topics and personnels' statements on each
topic (format is two columns: topic and comments. The comments column has
one row for each person to enter comments. There are a total of 10
people/rows.). However, at the present time, most topics have not been
commented on. How do I get my report to only show those comment fields that
are NOT blank? CanShrink will not work b/c of the layout of my report, and
the VBA option of creating a CanShrinkLines module is confusing me.

Thanks!
 
Hi Jacklyn,

I have run into this problem before also and found a "work-around" it. In
the report section's detail line where I wanted my "comments" to appear (IF
there were in deed comments), I included a comment field box that was as wide
as needed and then made the box VERY short top-to-bottom. I then designated
that the field could both "Grow" and "Shrink". If there were comments in
that section then comments would show up on the report. If there were no
comments, it merely left a very thin line "spacer" where that box was. This
has worked great for me and should for you also.
 
Back
Top