Access Page Setup - Columns Tab

[MzMoonpie]

I'm building a form in Access that I want to be able to print out and mail.
There are a few pages to the form, as there's lots of information I need.
The page setup will not allow me to go past 22". I've tried to change the
number in the columns tab under the Page Setup button, but it will not let me
go above 22".

Any help or suggestion is appreciated. I do not want to have to create the
form in Access to enter information and then create another form in Word then
PDF for printing and mailing. Waste of time.

 

[Beetle]

In Access you don't print Forms, you print Reports. You can use the report
wizard to create a report based on your form data. You may have to modify it
some in design view to get it to look the way you want, but it shouldn't be
too difficult.

 

[MzMoonpie]

The problem is I don't have the data to enter into the form yet, so I have to
print blank forms to mail out. I have no data with which to form a report.
Am I making this too difficult for myself?

 

[Beetle]

Access isn't designed for creating blank forms. You would be better off using
another program if that's what you are doing

 

[Dirk Goldgar]

The problem is I don't have the data to enter into the form yet, so I have
to
print blank forms to mail out. I have no data with which to form a
report.
Am I making this too difficult for myself?

As Beetle says, Access isn't really intended for this sort of thing. No
form can exceed 22" in height. What you might do is create each page of the
conceptual form -- the image of the form you have in your head -- as a
separate Access form. Then put each of these Access forms as a subform on a
different page of a tab control. Printing out a physical, multi-page form
to be mailed out would be a matter of printing each of the subforms (the
individual one-page forms that you have as subforms on the tabbed form)
separately.

 

[georgia wong]

Ummmm can you help me I am new to this so what is this?? Oh and also I am
Georgia

 

[John W. Vinson]

The problem is I don't have the data to enter into the form yet, so I have to
print blank forms to mail out. I have no data with which to form a report.
Am I making this too difficult for myself?

If you just want blank forms to be filled in with pencil or pen, I'd suggest
building them in Word or Publisher. Just visually match the desired Access
form, if that's important. It may not be critical, actually; the decisions
involved in creating a paper form are (or should be) different than those
involved in creating an onscreen data entry tool. Paper forms can't have
scroll bars, dropdown combo boxes, tab pages that let you share space between
multiple controls - onscreen forms can and should.

John W. Vinson [MVP]