Access screen not repainting properly after printing a report

[Todd M.]

In my Access 2003 db I have an order entry screen. Everything works fine
until the user presses one of the print buttons for the various reports. The
button send the reports directly to the printer (not a print preview). The
following is the code I use to print the report.

Private Sub cmdPrintSalesOrder_Click()
On Error GoTo Err_cmdPrintSalesOrder_Click

Dim stDocName As String
Dim stDocName2 As String
Dim stDocName3 As String
Dim stFilter As String

stFilter = "[OrderID] = " & Me.OrderID.Value

stDocName = "r_Sales_Order_Without_Price"
stDocName2 = "r_Sales_Order_With_Price"
stDocName3 = "r_Sales_Order_File_Copy"

DoCmd.OpenReport stDocName, acViewNormal, , stFilter
DoCmd.OpenReport stDocName2, acViewNormal, , stFilter
DoCmd.OpenReport stDocName3, acViewNormal, , stFilter

Exit_cmdPrintSalesOrder_Click:
Exit Sub

Err_cmdPrintSalesOrder_Click:
MsgBox Err.Description
Resume Exit_cmdPrintSalesOrder_Click

End Sub

When it is finished some of the text in the text boxes and buttons on the
order entry screen have a bold font and a white background. This stays
messed up in design view and it also distorts the property screens for these
objects in design view. If you close access and open it up again everything
is fine, until you print another report. If a screen shot would help I can
send one to whoever is interested. This is very anoying and I find it
occuring in Access 2002, Access 2003, Access 2003 SP1.

Any help would be appreciated.

Thanks,

Todd M.

Email: tmarshall at millertruck.com replace " at " with @

 

[Wayne Morgan]

The first thing I would try would be to verify that the printer and video
drivers are the most current ones available. Next, make sure your Office and
Windows service packs and patches are up to date. If that doesn't help and
you're using Windows XP, try turning off the XP style windows and use the
Classic Desktop instead and see if that helps. I have also seen problems
with video corruption in Access 2003 reports if the report is set to
Preview, you have Auto Center or Auto Resize (it's one or the other, but I
don't remember which at the moment) set to Yes, and you maximize the report
in the report's Open event. But, as you say, you aren't previewing.

 

[Todd M.]

Thanks for you suggestions Wayne. I found the problem to be the code that
was firing in the report open event to maximize the screen. When I commented
out that code the problem does not occur.

Thanks again

The first thing I would try would be to verify that the printer and video
drivers are the most current ones available. Next, make sure your Office and
Windows service packs and patches are up to date. If that doesn't help and
you're using Windows XP, try turning off the XP style windows and use the
Classic Desktop instead and see if that helps. I have also seen problems
with video corruption in Access 2003 reports if the report is set to
Preview, you have Auto Center or Auto Resize (it's one or the other, but I
don't remember which at the moment) set to Yes, and you maximize the report
in the report's Open event. But, as you say, you aren't previewing.

--
Wayne Morgan
MS Access MVP

In my Access 2003 db I have an order entry screen. Everything works fine
until the user presses one of the print buttons for the various reports.
The
button send the reports directly to the printer (not a print preview).
The
following is the code I use to print the report.

Private Sub cmdPrintSalesOrder_Click()
On Error GoTo Err_cmdPrintSalesOrder_Click

Dim stDocName As String
Dim stDocName2 As String
Dim stDocName3 As String
Dim stFilter As String

stFilter = "[OrderID] = " & Me.OrderID.Value

stDocName = "r_Sales_Order_Without_Price"
stDocName2 = "r_Sales_Order_With_Price"
stDocName3 = "r_Sales_Order_File_Copy"

DoCmd.OpenReport stDocName, acViewNormal, , stFilter
DoCmd.OpenReport stDocName2, acViewNormal, , stFilter
DoCmd.OpenReport stDocName3, acViewNormal, , stFilter

Exit_cmdPrintSalesOrder_Click:
Exit Sub

Err_cmdPrintSalesOrder_Click:
MsgBox Err.Description
Resume Exit_cmdPrintSalesOrder_Click

End Sub

When it is finished some of the text in the text boxes and buttons on the
order entry screen have a bold font and a white background. This stays
messed up in design view and it also distorts the property screens for
these
objects in design view. If you close access and open it up again
everything
is fine, until you print another report. If a screen shot would help I
can
send one to whoever is interested. This is very anoying and I find it
occuring in Access 2002, Access 2003, Access 2003 SP1.

Any help would be appreciated.

Thanks,

Todd M.

Email: tmarshall at millertruck.com replace " at " with @