[AccessD] Scale Access Report To Fit

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