Closing up Blank fields on a report

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
 
D

Duane Hookom

Have you tried to set the Can Shrink property to Yes?

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