Removing Spaces in a vertical Access Report

[Guest]

I have a database report that has the ability to list 20 fields of comments
under each of my customers. The challenge is that I don't have 20 comments
per customer and my report looks whacky. When I view the report, i have
large spaces where there is no text in one of the 20 fields.

Customer #1
Good paying
address
yada yada


(I WOULD LIKE THIS SPACE REMOVED ON MY REPORT AS BOXES 4-20 ARE NOT
POPULATED, BUT THEY SHOW ON THE REPORT AS A BLANK LINE)



Customer #2
YADA
YADA
YADA

Is there anyway to set the report to remove the spacing in the report when
the value in the field is null?

 

[Duane Hookom]

Try set some text box Can Shrink properties to Yes.

 

[Guest]

Duane, thanks for the feedback. The Can Shrink properties should be set to
Yes for the Detail section not just the individual text boxes and it clears
it up.

Awesome, thanks for your help
--
Kelly

Try set some text box Can Shrink properties to Yes.

 

[Guest]

Thanks, it was Can Shrink properties for the whole detail section! Awesome
--
Kelly

Try set some text box Can Shrink properties to Yes.