Closing up Blank fields on a report

  • Thread starter Thread starter Matthew Wayne
  • Start date Start date
M

Matthew Wayne

I have a report design where names are listed down in
columns. I have provision for several fields in the
design view, but sometimes these field are blank in some
records. When I run the report, it allows spacing for
all the fields shown in Design view.
Is there any way I can tell the system to close up the
vertical space on the report when not all the fields are
required?
Report Preview EG: Record 1
John
Henry
Tom
Bill
Record 2
Tom
Bill

Thanks for any help
 
Have you tried to set the Can Shrink property to Yes?

It also seems that your table structure might be un-normalized.
 
Back
Top