Re: report not wide enough to make required Excel spreadsheet

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Sep 30, 10:49 am, BetoWing <BetoW...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I need to make an Excel spread*** with 30 or more fields which come from an
Access report. The Access report I make is max. 14 inches wide based on the
paper size as though I am printing on paper, but I am just using 'Office
Links' to create the spread***.

How can I make my Access report wide enough to hold all of the fields?
There is a 'user defined' paper size, but how do I define the paper size?
--
BobWingmeister

Don't use an Access Report. Make an Access Query and export that to
Excel. A Report width is limited by page size - but Excel doesn't
care.

On the other hand, have you thought of making the textboxes in the
Report narrower so that they fit within whatever paper size you set?

HTH
Ananda

.

Quantcast