Can Shrink on a report

[Denise]

I have a report that shows only what is checked off yes in
a yes/no field. Now I want those fields to move and line
up correctly on the report. I used the Can Shrink/Can
Grow but my reports is still all over the place and not
lined up correctly. Any suggestions?

Thanks,

 

[Fons Ponsioen]

If with "all over the place" you mean there are still
blank lines or if there are still labels that are printed
even when you have no data?
If you still have blank lines, make sure the can shrink
property is set for the report band in which the data
resides.
If the labels are still printing even though there is no
data, In order to delete (hide) the label when the data is
null, you need to provide appropriate code, such as an IIF
statement in the label (you convert the label to a textbox
first) or you can write code to set the property "visible"
to yes or no as appropriate.
Hope this helps.
Have a Hapy Thanksgiving.
Fons

 

[Denise]

I mean that there are still blank lines in between the
fields on the report. I made sure the report and the
fields all have can shrink and can grow and still does not
work right...any other suggestions.

Thanks for the information.

Denise

 

[Fons Ponsioen]

If you have totally blank lines, Make sure that the
adjacent data fields are small and that there is not a
group footer in between. Which report band is the source
of this problem? And you have set the can shrnk property
for this specific band to yes?
Fons