D
Dennis
I am trying to put a border around my reports; here is the code that I found
in the news group help file.
Me.DrawWidth = 2
Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), B
I am using the below code module to preview my reports, I have over 20
reports so I just call the PreviewThisReport function, from within the form
that I need to preview the report from. Where would I put the above code or
would I have to change the code? Is there an easier way to do it? VBA is some
what new to me. I guess I don’t understand the “Me.†Keyword. Help would be
appreciated.
'function Previews report
Function PreviewThisReport(strReportName As String)
On Error GoTo IsLoaded_Err
'find preview report
DoCmd.OpenReport strReportName, acViewPreview
DoCmd.RunCommand acCmdFitToWindow
DoCmd.RunCommand acCmdZoom75
Exit Function
IsLoaded_Err:
Resume Next
End Function
in the news group help file.
Me.DrawWidth = 2
Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), B
I am using the below code module to preview my reports, I have over 20
reports so I just call the PreviewThisReport function, from within the form
that I need to preview the report from. Where would I put the above code or
would I have to change the code? Is there an easier way to do it? VBA is some
what new to me. I guess I don’t understand the “Me.†Keyword. Help would be
appreciated.
'function Previews report
Function PreviewThisReport(strReportName As String)
On Error GoTo IsLoaded_Err
'find preview report
DoCmd.OpenReport strReportName, acViewPreview
DoCmd.RunCommand acCmdFitToWindow
DoCmd.RunCommand acCmdZoom75
Exit Function
IsLoaded_Err:
Resume Next
End Function