Change the VBA code behind the button to the following: DoCmd.OpenReport "reportname", acViewPreview
- Pete _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Boehm, Gary D. Sent: Friday, March 14, 2008 9:52 AM To: '[email protected]' Subject: [ms_access] Report - prints without preview Access 2002 SP3 I inherited a database where the reports go straight to the user's default printer. How do I change the reports so they show up in preview mode instead of going straight to the printer? Gary [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
