Printed report vs on-screen report

[medic133]

I have a report that is based on a crosstab query. The footer of the report has text boxes for totals for the columns in the detail section. In the detail section there is a gray, hairline line seperating each record returned. What I'd like to do is after the last record is listed on the report and before the totals are listed, change the line from the gray to a bolder black line. I have done this and my code looks something like this:

Dim rstReport As DAO.Recordset

If rstReport.EOF then
Me.Linenumber.Borderwidth=2
Me.Linenumber.BorderColor=0
End if

When viewing print preview, the report looks fine, however when I print it, all of my horizontal lines seperating my records in the detail section have the above characteristics. I've printed to 2 printers and the same thing happens. Is this a problem with my code or with the printers? Thanks in advance.

 

[medic133]

If it matters, the above code is in my detail_format section of my VBA code. Thanks.

 

[RiverGuy]

Do you have a group section for the totals? If so, I would say add a dark black line at the top of that.