Report goes off the right of the page, but only on some computers

[gellerche]

I have a VB front end that uses an Access database for data and to make reports. The front end passes parameters to the Access report, sends the report to a snapshot file, and then opens a VB form that contains the snapshot. This works fine. The problem is that when he runs the front end, his report overflows to the page on the right (e.g.: A one page report will become two). The exact same report does not overflow to the right when run on my computer.

We both used the exact same options to create the report, and used the exact same data (We each have a separate Access database on our hard drive, but the database on his drive is an exact copy of mine.). This report is done in landscape.

I don't know if the code'll help, but here it is.

:

 With AccessObj 
        .OpenCurrentDatabase gblDatabaseLocation, False 
        .DoCmd.Maximize 
        .Visible = False 
        Screen.MousePointer = vbHourglass 
        Snapshotfile = App.Path & "\Report.snp" 
        Snapshotfile = Replace(Snapshotfile, "/", "-") 
        .DoCmd.OpenReport "rptSoftwareInventory", acViewPreview, , SQL 
        .DoCmd.OutputTo acOutputReport, "rptSoftwareInventory", acFormatSNP, Snapshotfile, 0 
        frmReportOutput.SnapshotViewer1.SnapshotPath = Snapshotfile 
        frmReportOutput.Show 
        .Visible = True 
        .CloseCurrentDatabase 
        .Quit 
        Set AccessObj = Nothing 
        Screen.MousePointer = vbNormal 
    End With

Does anyone know what I can do to keep the report on one page?

Thank you for your help,

Steve Geller

 

[Pat Hartman]

If you can compress some horizontal space by shifting everything left or by reducing the margins, do so. You may also need to update the drivers on the PC that is not printing properly.