[AccessD] [Fwd: Default Page Size]

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
>
>   




More information about the AccessD mailing list