[AccessD] Scale Access Report To Fit

If all of the fields are the same size...could you loop through each 
control...and adjust the fields left and width one at a time...each 
dependant on the one before...I believe the unit of measure would be 
twips?...anyway...just an idea...

Mark A. Matte


>From: "Liz Doering" <ldoering at symphonyinfo.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Scale Access Report To Fit
>Date: Tue, 11 Jul 2006 11:00:20 -0500
>
>If there really are more columns than fit on a landscape report, would
>the department manager find a option to export all the columns to Excel
>more useful?  Then they can play with it to their heart's content.
>
>This has worked for me with a bunch of cities who have nasty complicated
>capital improvement planning reports.  They have been delighted to find
>their data could be made available in their favorite Excel format, and I
>have quietly breathed huge sighs of relief, since an export is so much
>easier.
>
>Liz
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>paul.hartland at fsmail.net
>Sent: Tuesday, July 11, 2006 10:15 AM
>To: accessd
>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
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com