Report Printing Automatically Issue The Merg 12/31/2008 5:19:01 AM I have a Form that when a button is pressed, it performs the DoCmd.OpenReport command. Whenever the report is opened, it automatically prints. I am racking my brain trying to find what setting I changed to have this happen and am having a complete brain fart on this. I have even created a brand new report and the issue is still there. I know the fix is simple, but I can't remember where this setting is. Thanks, Merg -- Today''s problems don''t worry me, I haven''t solved yesterday''s yet.

RE: Report Printing Automatically Issue Clifford Bass 12/31/2008 6:23:00 AM Hi, Use the acViewPreview setting: DoCmd.OpenReport "rptMyReport", acViewPreview Clifford Bass "The Merg" wrote: [Quoted Text] > I have a Form that when a button is pressed, it performs the DoCmd.OpenReport > command. Whenever the report is opened, it automatically prints. I am racking > my brain trying to find what setting I changed to have this happen and am > having a complete brain fart on this. I have even created a brand new report > and the issue is still there. I know the fix is simple, but I can't remember > where this setting is. > > Thanks, > Merg > -- > Today''s problems don''t worry me, > I haven''t solved yesterday''s yet.

Re: Report Printing Automatically Issue "The Merg" <howard_mergler[ at ]NOSPAM.themerg.net> 12/31/2008 6:55:57 AM Yeah... I knew it was going to be something that simple. Been a while since I've worked in Access... Thanks, Merg -- Today's problems don't worry me, I haven't solved yesterday's yet. "Clifford Bass" <CliffordBass[ at ]discussions.microsoft.com> wrote in message news:09928551-DA0B-4F0C-B92F-879F6357C835[ at ]microsoft.com... [Quoted Text] > Hi, > > Use the acViewPreview setting: > > DoCmd.OpenReport "rptMyReport", acViewPreview > > Clifford Bass > > "The Merg" wrote: > >> I have a Form that when a button is pressed, it performs the >> DoCmd.OpenReport >> command. Whenever the report is opened, it automatically prints. I am >> racking >> my brain trying to find what setting I changed to have this happen and am >> having a complete brain fart on this. I have even created a brand new >> report >> and the issue is still there. I know the fix is simple, but I can't >> remember >> where this setting is. >> >> Thanks, >> Merg >> -- >> Today''s problems don''t worry me, >> I haven''t solved yesterday''s yet.