Printing Problem

  • Thread starter Thread starter B F Cole
  • Start date Start date
B

B F Cole

The portion of code below is attached to the On Click Event of a button on a
form. The idea is to allow a user to preview or print a report. Here's the
problem. When the user selects preview (Yes), the report is displayed on
the screen in perfect format and data. If the user then decides to print
the report by File>Print or CTRL P, the first field on the first detail line
is blank If the user decides to print the report (No) without preview, all
of the data is correctly printed in the proper format. I'm running Windoxs
XP Pro SP2 and Access 2003 SP2.

Any ideas on what's causing this problem and a fix?

iAnswer = MsgBox("PREVIEW Call List or PRINT Call List?... Click YES to
PREVIEW...NO to PRINT...", vbQuestion + vbYesNo)
Select Case iAnswer
' Preview Call List
Case vbYes
stDocName = "rptCallList"
DoCmd.OpenReport stDocName, acViewPreview
Case vbNo
' Print Call List
stDocName = "rptCallList"
DoCmd.OpenReport stDocName, acViewNormal
End Select

Thanks for your usual fine suggestions,
Bill
 
Code looks fine to my untrained eye, only thought is, is 'hide duplicates'
set to yes for theat field in the report?

TonyT
 
Back
Top