Print Style different from preview style

[lxh]

Hi All

I've created a report style that I've used in all my reports (called prince). I'm really happy with it's lay out an style etc., in the preview mode in access. I've just added a button to print our the report the file, but most of the formating is lost. The code I've used is:

Private Sub Statistics_Click()
On Error GoTo Err_Statistics_Click

    Dim stDocName As String

    stDocName = "Numeracy Statistics"
    DoCmd.OutputTo acReport, stDocName, acFormatRTF, "Stats.rtf"

Exit_Statistics_Click:
    Exit Sub

Err_Statistics_Click:
    MsgBox Err.Description
    Resume Exit_Statistics_Click
    
End Sub

All my fancy colours and pictures have gone - has any one solved this type of problem or know how to?

Thanks
Lex

 

[lxh]

Thanks Pat

This is not a bug. This is how the export works. The options to export a report to Word or Excel will LOOSE ALL graphic elements. If you want to retain them, export the file as a snapshot or buy the program that lets you export them as a .pdf.

There is certainly no reason for the graphic elements to be lost since the .rtf and .xls formats both support lines and boxes, etc. But that's just the way it is.

Thanks for your help Pat, your right - I'm using snapshots instead.
Lex