vary height of detail in report

S

simon

I have a table where not all fields are populated for all
records. e.g.
Part#, Field1, Field2, Field3, Field4
1 , abc , def , ghi, jkl
2 , mno , abc ,
3 , abd , bcd , lmn

I am having trouble making a report. I want to show a in
the detail of the report each part# with the fields listed
down the page under it. eg.
1
abc
def
ghi
jkl

2
mno
abc



But when it does part# 2 it lists two fields with data but
also prints two blank fields. This makes the report very
large. How can i list this data down the page but get the
report height to vary (shorten for those with fewer
populated records).
(This is only an example as there are many fields and the
report is currently huge and full of blank spaces).

Any help would be appreciated.

Thanks
 
F

fredg

I have a table where not all fields are populated for all
records. e.g.
Part#, Field1, Field2, Field3, Field4
1 , abc , def , ghi, jkl
2 , mno , abc ,
3 , abd , bcd , lmn

I am having trouble making a report. I want to show a in
the detail of the report each part# with the fields listed
down the page under it. eg.
1
abc
def
ghi
jkl

2
mno
abc

But when it does part# 2 it lists two fields with data but
also prints two blank fields. This makes the report very
large. How can i list this data down the page but get the
report height to vary (shorten for those with fewer
populated records).
(This is only an example as there are many fields and the
report is currently huge and full of blank spaces).

Any help would be appreciated.

Thanks
Click to expand...

Set the Can Shrink property of each control to Yes.
As long as no other control is on the same line, the next control down
will move up.
Also set the Detail Section's Can Shrink property to Yes.
 
Top