FACTS
I designed a report that looks great in layout preview on the screen.
The report includes text boxes. The text boxes have borderlines (black / hairline). The borderlines are clearly visible in the layout view of the report. Furthermore, the report has rows with alternate colors which was done with the following VBA code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Const Grey = 16777215
Const White = 12632256
Me.Detail.BackColor = IIf(Me.Detail.BackColor = White, Grey, White)
End Sub
All in all, I am happy with the style of the report when I look at it on the PC screen.
PROBLEM:
Unfortunately, when I print the report, the following is not printed correctly (not matching with layout view of the report):
- the borderlines are not printed.
- the text/numbers in the text boxes are surrounded by a white area. This is not the case in the layout view of the report
- there are different fonts. However, all text boxes should have the same font
Do you know what causes this problem? Any idea how to resolve it?
I designed a report that looks great in layout preview on the screen.
The report includes text boxes. The text boxes have borderlines (black / hairline). The borderlines are clearly visible in the layout view of the report. Furthermore, the report has rows with alternate colors which was done with the following VBA code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Const Grey = 16777215
Const White = 12632256
Me.Detail.BackColor = IIf(Me.Detail.BackColor = White, Grey, White)
End Sub
All in all, I am happy with the style of the report when I look at it on the PC screen.
PROBLEM:
Unfortunately, when I print the report, the following is not printed correctly (not matching with layout view of the report):
- the borderlines are not printed.
- the text/numbers in the text boxes are surrounded by a white area. This is not the case in the layout view of the report
- there are different fonts. However, all text boxes should have the same font
Do you know what causes this problem? Any idea how to resolve it?