Space between lines in MS Access Report

[rpatil]

I need to reduce space between lines in a custom paper size report that I need to create for a label.

My report custom paper size is 5.75 Inch x 1.75 Inch and the filed is

Font Name: Times New Roman
Font Size: 6
Can Grow: Yes
Can shrink: Yes

Section Detail Height: 0.0833" --- Reducing this value dose not reduce the space between lines

I tried VBA Private Sub Report_Open(Cancel As Integer)

Me.Detail.Height = 3

and
rpt.Section(acDetail).Height = 10

but could not reduce the space between lines.

When I open the report I can see that there is space between lines that can be reduce ( I just need a hair line space between two lines)

Dose any one know how to fix this problem


Thanks
Rahul

 

[boblarson]

You need to manually put your mouse over the bar that separates the detail section from the footer until it becomes a black line with two arrows and then click and drag it up to where you want it.