[AccessD] Scale Access Report To Fit

If he wants a landscape report, why would you have trouble fitting in
the columns, unless you were splitting it across two pages before?
Access reports don't have that kind of size to fit capability, although
you could do it by saving the report to pdf format and printing from the
pdf.


Charlotte Foust

-----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 8:09 AM
To: accessd
Subject: [AccessD] Scale Access Report To Fit
Importance: High

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