[AccessD] [Fwd: Default Page Size]

I don't know if it would work there, Rocky.  Reports can be very
resistant to design changes in their Open events, but you could try it
by passing the papersize in to the report in OpenArgs and letting it set
its own papersize.  Another alternative if that didn't work would be to
dim a report object in the calling code, set to the report you're
opening and set the report's printer property from there.  

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 8:43 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] [Fwd: Default Page Size]



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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com