[AccessD] [Fwd: Default Page Size]

Charlotte:

Thanks.  I'll try both.  But I'll have to test it long distance.  No A4 
paper here, and I don't know if I'd see any difference on my printer.  
As soon as this guy's back in Bangalore, we'll give it a go.

Best,

Rocky


Charlotte Foust wrote:
> 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
>>
>>   
>>     
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com