Adding Lines to Database Report

[SantasLittleHelper]

Is there a way of adding a horizontal line on the access report after every 15 records?
E.g.
Client 13
Client 14
Client 15
__________
Client 16
Client 17
....

 

[Joe4]

Well, you can underline your values using Conditional Formatting.

First, add a Counter to the Detail section of your Report to count each record.
Follow Allen Browne's directions for Reports at the top of this article here: Microsoft Access tips: Numbering Entries in a Report or Form
Let's then name this Text Box "txtCounter".

Now, go to the field you want to underline, right-click on it, and select Conditional Formatting.
Under "Condition 1", change the drop-down box to "Expression Is" and enter this formula:

[txtCounter]/15=Int([txtCounter]/15)

Then select the underline option.

You can do this for other fields too, if you are showing more than one. Just repeat the same Conditional Formatting steps with those fields.

Note that if you do not actually want to see the counter on the report, just change the Visible property of that "txtCounter" Text Box to "No".

 

[HiTechCoach]

It is very easy.

1) add a textbox to the row.

Control Name: txtCount
visibel= No
control source:=1
Runnig sum: Over All

2) add a line to the row below the controls

Control Name: MyLine

3) In the detail section's "On Print" event add an [Event Procude]

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
   ' make the line visible after each group of 15 records
   MyLine.Visible = ((Me.[txtCount] \ 15) * 15 = Me.[txtCount])

End Sub

TIP: The trick is to use integer division with \ not /.

Me.[txtCount] \ 15 is the same as Int(Me.[txtCount] / 15)

 

[Joe4]

Oh sure Boyd, now you come along!
After over 32 hours of the question being unanswered, you answer the same hour that I do!
I spent some time trying to figure out if one could apply Conditional Formatting to lines (it appears not), and didn't even consider going the VBA route instead.
You could have come along an hour earlier and saved me the trouble!!!

 

[HiTechCoach]

Oh sure Boyd, now you come along!
After over 32 hours of the question being unanswered, you answer the same hour that I do!
I spent some time trying to figure out if one could apply Conditional Formatting to lines (it appears not), and didn't even consider going the VBA route instead.
You could have come along an hour earlier and saved me the trouble!!!

We must have seen this abut the same time. I was testing my theory also. While testing the phone rang and I was delayed about an hour. Otherwise, we probably would have posted a reply about the same time.

 

[SantasLittleHelper]

Haha thanks both of you