Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Breaks in Reports

Status
Not open for further replies.

evbo

Programmer
Joined
May 22, 2002
Messages
2
Location
US
I am doing a ranking report and want to put a break line every five entries. Does someone know how to set this up so that after every five lines it will print a line across the page. Thanks
 
Create a blank line textbox object and a line counter

Make the text box visible after every 5 line counter
use can shink can grow property at detail section

mvCNT = mvCNT + 1
If mvCNT > 5 Then
me!txBLANK.visible = true
mvCNT = 1
else
me!txBLANK.visible = False
end if

Hope that helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top