[AccessD] Scale Access Report To Fit

...iirc, Lebans (lebans.com) has some code that will auto size the font to 
fit the text in a spec text box size.

William

----- Original Message ----- 
From: <paul.hartland at fsmail.net>
To: "accessd" <accessd at databaseadvisors.com>
Sent: Tuesday, July 11, 2006 11:09 AM
Subject: [AccessD] Scale Access Report To Fit


> To all,
>
> I have a problem which I am hoping I can be proved wrong on, basically I 
> am writing an internal application (which is almost finished) and the 
> problem lies in the reports.  The manager of the department it is for 
> wants the report to fit on A4 landscape, now the amount of columns that 
> there is in the report makes this impossible without shrinking all the 
> textboxes to about 6pt and moving them all about.  Is there something out 
> there (or within access that I doubt) that is similar to the options you 
> get in excel (shrink to fit, or reduce the percentage etc).  I know I can 
> export to RTF/Excel etc and then play, but the reports need playing about 
> with a little even after the export.
>
> Thanks in advance for any help on this.
>
> Paul Hartland
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>