Too many fields on report

  • Thread starter Thread starter kit
  • Start date Start date
K

kit

Hi
I have a report with 30 fields that obviously will not fit
on a page.
I am looking for tricks to do this.
If I could get the field headings to wrap down a line* I
could save a lot of space but cannot see anything in the
text box properties to enable this.
So desperate I even tried Alt and enter like Excel!
Help will be gratefully received

Thank You
* i.e
Trade forecasts becomes:
Trade
Forecasts
 
kit said:
Hi
I have a report with 30 fields that obviously will not fit
on a page.
I am looking for tricks to do this.
If I could get the field headings to wrap down a line* I
could save a lot of space but cannot see anything in the
text box properties to enable this.
Click to expand...

Use Shift-Enter to create a new line in a heading text box so instead of
_________________________
|This is a Long Header |
|________________________|
you can have

________
|This |
|is |
|a |
|Long |
|Header |
|_______|
and make the header text boxes narrower. Just use Shift-Enter after every
word in the header text box.

Tom Lake
 
Control Shift will work - that forces the text to go to
the 2nd line.
You can also do this another way.

In the properties of the label field- make sure the
property "CAN GROW" is set to YES.
Then make your label field as narrow as you need - Access
will automatically try to accomodate the width of the
field and make it longer if the label needs more room.
Sometimes it doesn't split the text where you want it - so
you have to play with the width or use the Control Shift
option.

Ann
 
Back
Top