Removing Spaces in a vertical Access Report

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

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, 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


Duane Hookom said:
Try set some text box Can Shrink properties to Yes.
Click to expand...
 
Back
Top