Spacing in detail section

[david]

I have a ton if data printing on a single line, landscaped
on 8.5 x 14. What I'd like to do (for clarity in using
this report) is put a small space underneath each 5th
line. Is this possible? Thanx - David

 

[Duane Hookom]

You could add a text box in the detail section with:
Name: txtCount
Control Source: =1
Running Sum: Over All
Can Grow: Yes
Can Shrink: Yes
Back Color: Transparent
Fore Color: 16777215 'white
You shouldn't be able to see this and may want to send it to the back.
Then add code to the On Format event of the detail section:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtCount Mod 5 = 0 Then
Me.txtCount.FontSize = 20 'adjust
Else
Me.txtCount.FontSize = 8 'adjust
End If
End Sub

 

[david]

That did it !!!! Thanx a gazillion

-----Original Message-----
You could add a text box in the detail section with:
Name: txtCount
Control Source: =1
Running Sum: Over All
Can Grow: Yes
Can Shrink: Yes
Back Color: Transparent
Fore Color: 16777215 'white
You shouldn't be able to see this and may want to send it to the back.
Then add code to the On Format event of the detail section:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtCount Mod 5 = 0 Then
Me.txtCount.FontSize = 20 'adjust
Else
Me.txtCount.FontSize = 8 'adjust
End If
End Sub


--
Duane Hookom
MS Access MVP





.