HELP with Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

v - 25 Sep 2007 00:26 GMT

I have data from a table that I would like to have appear on a form. When I
print out the form it give me sixty two pages of forms. How can I set the
form up so that i will make four to a sheet? It is only printing two fields
to a sheet...They are not to big either size wise...I just need to figure out
what setting allows me to print multiple numbers of the same form to a sheet.

Reply to this Message

Albert D. Kallal - 25 Sep 2007 01:30 GMT

Use a report for this.

You can use the wizard, or build the report from scratch.

Simply place the two fields on the form. You can then go into page setup,
and have multiple columns. You can pack a LOT of data on a page by doing
this....

When you in report design mode, go file->page setup. You see a tab called
"columns"

Note that you have to have make the column of your data not too wide, else
you not fit more then "one" column of data on a page....

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

SteveM - 25 Sep 2007 01:46 GMT

You could choose Properties and set an appropriate option. For example, my
printer has a 'Pages on Sheet' option.

So you need to get the print dialog up and then click Properties.

If it someting you are going to do often, it would be better to set up a
report to do this. You could then supply criteria to the report to print
certain type of data.

Steve

> I have data from a table that I would like to have appear on a form. When I
> print out the form it give me sixty two pages of forms. How can I set the
> form up so that i will make four to a sheet? It is only printing two fields
> to a sheet...They are not to big either size wise...I just need to figure out
> what setting allows me to print multiple numbers of the same form to a sheet.

Reply to this Message