Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Jan 26 22:43:28 CST 2006
So, right code, wrong place? Should be in the open event of the report? TIA Rocky Charlotte Foust wrote: > All you're doing there is setting the paper size of the printer object. > You need to work the the Report's printer object. > > Charlotte Foust > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > - Beach Access Software > Sent: Thursday, January 26, 2006 9:25 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] [Fwd: Default Page Size] > > > Charlotte: > > I put this code: > > If Me.fraPaperSize = 1 Then > Access.Printer.PaperSize = acPRPSLetter > Else > Access.Printer.PaperSize = acPRPSA4 > End If > > > into the event that calls the report in question. On my printer it > doesn't print any differently with either setting but I would expect > that, I guess as I haven't got any A4 paper to test it with. I'll send > it to the user to see if it solves the problem. > > But have I got the code right? Should it go in the open event of the > report itself instead of the calling procedure in the form? > > MTIA, > > Rocky > >