Spacing in detail section

  • Thread starter Thread starter david
  • Start date Start date
D

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





.
Click to expand...
 
Back
Top