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

[rpatil]

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


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

 

[razorking]

Just a suggestion, and it may not solve your problem as I am having some difficulties in visualizing exactly what you want and what is actually happening:

Try setting the report detail properties to can grow - NO - see if that has any effect one way or other