Multi-page Forms Help!!

[apryor]

I'm sure this is a simple solution, but I just can't seem to figure it out. I'm designing a form that I would like to be 3 pages long. When I'm in Design view, I can extend the bottom of the page to about 22 inches, based on the side ruler, but not far enough to create a third page. I tried adding a page break, but when I switch to print view, information from the form seems to skip a page. Any help is greatly appreciated. Thanks.

AP

 

[VBslammer]

22 inches? Sounds like you're trying to turn your form into an 8.5 X 11 report, eh? I've never seen anyone do that with multiple pages. You should really try to create a report based on the data from your form.

See this link for a brief example of how multi-page forms are typically setup (it's a long thread, look toward the end of it):

Multi-Page Form Suggestion

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[apryor]

Thanks for the info, I'll try out your page break example.

I'm trying to create forms in access that match the look of some word doc's, most of which are 2 pages, but now I have one that's 3 pgs. Is there an easy way to pass the info from my form to a report? I'm sure there's a way to do it in VBA, but unfortunately, I only just started learning VBA.

 

[VBslammer]

Create a report that looks like the document you're copying, and has the same fields as the form (same RecordSource). In the Report_Open() event, you can check if the form is open and filter the report's records based on the primary key of the form's current record, something like this:

Private Sub Report_Open(Cancel As Integer)
  
  If CurrentProject.AllForms("frmMain").IsLoaded Then
    Me.Filter = "[CompanyID]=" & Forms!frmMain!CompanyID
    Me.FilterOn = True
  End If
  
End Sub

VBSlammer

"You just have to know which screws to turn." - Professor Bob