CAN GROW: YES ---Adds extra space between report lines

[rahul patil]

MS Access Report: Can Grow property set to Yes or No versus Line Space?

I have a MS Access report that I have created with a custom paper size of
5.75 inch x 1.75 inch , and the fields in this report are set to Font Size:
6

I have set height of all fields in report to 0.09" this is the height I want
so that there is no extra space between lines --- The report looks fine with
exact line spacing how I want ( with Can Grow: No)

BUT when I change the CAN GROW property of all fields to: YES it adds the
extra space between the lines that I do not want.

I have tried to reduce the space between the lines by VBA code

VBA Private Sub Report_Open(Cancel As Integer)

Me.Detail.Height = 30
rpt.Section(acDetail).Height = 30

but this dose not have any effect on space between line it can increase
space between line if I set height to more than 150 but below 150 it dose
not reduce the line space.

It has to do some thing with CAN GROW: YES properties

Can anyone suggest me how can I fix this problem



Is there a way to give conditional cangrow for example if the number of
characters in a filed is greater than say 100 it can grow else do not grow.

I am trying to fit 31 to 37 lines in my custom paper size report , and my
data structure is such that for all structure type only the first record is
greater than 150 and all remaining are below 100 characters.

So it will be ideal if the cangrow property work only for first row and
after that the remaining row need not expand/grow.

This will give the result that I want but I am not able to set cangrow
property to yes based on a criteria ,

Is this Possible ????

Thanks
Rahul