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
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