Distributing Fields in a report

A

AmandaH

I have and interesting problem, I am using Access 2003 and I have
created a report from a Form. This works find, however the report is
too long to fit on one page. I added a page break to make it look
better. However because I have reached the maximum height of a report
in Access (55.5) I am unable to distribute my field down the page. What
I have ended up with is two pages where the fields are all bunched at
the top. Is there a way in Assess to make the length of a report longer
or a setting that will allow me to distribute there fields evenly,
taking up the full length of a legal size sheet of paper.

Thanks,

~Amanda~
 
G

Guest

If you do not have any memo fields you can build a record that each field has
the maximum amount of data and then alternate between design and view to
place your fields to occupy the legal size. Set the Grow and Shrink property
to No.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memo fields on a Report 2
Access Can't Open a report in MS Access 2007 0
Fields not showing on Report 7
Packaging and distributing Access 2003 solutions 2
Maximum of fields in a report 12
Consecutive record fields in a report 1
Consecutive record fields in a report 6
Can't create a report from my query in Access 1

Top