Form Paging

Paula222 · April 8th, 2006, 03:42 PM

Hi ,
I have i form in design view and it can contain only one page , but i want to add few pages to the form . how can i do that?

Bob Bedell · April 8th, 2006, 04:08 PM

The PageBreak control is a standard Toolbox control. Just drop one on your form where you want the next page page begin. Then place previous page and next page Command Buttons in each page section of the form as appropriate, and navigate betweeen pages with code like:

Code:

Private Sub cmdNextPage12_Click()
    DoCmd.GoToPage 2
End Sub

Private Sub cmdNextPage23_Click()
    DoCmd.GoToPage 3
End Sub

Private Sub cmdPreviousPage31_Click()
    DoCmd.GoToPage 1
End Sub

HTH,

Bob

Paula222 · April 9th, 2006, 06:48 AM

But how do i create the separate pages???it allows me to create only one page.

Bob Bedell · April 9th, 2006, 09:25 AM

You work with the single form at design-time, but the PageBreak control breaks the form up into multiple pages at run-time.

Unless you're talking about Tab Control pages.

To create multiple pages with the PageBreak control, place a few control on a form, add a page break control. That'll display page on at run-time. On the same form in design-view add come more controls. Then add another PageBreak control. Everyyhing between the first and second page break control will display as page 2 at run-time, etc...etc...

Bob

Paula222 · April 9th, 2006, 11:41 AM

The Page Break control doesn't seem to work at all . It doesn't separate the pages , and if i add buttons , it also doesn't help.

Bob Bedell · April 9th, 2006, 05:36 PM

The form has to be minimized. For example, if you set the page break control 3" down the form, you can only display a 3" form. In fact, you should set the Max Min Buttons property to none so that it can't be maximized. Save the form in design view, close it, then double click the form to open it to its display size. You might find a Tab Control with multiple pages suits you better. Play around with both and see.

Bob

Paula222 · April 10th, 2006, 06:03 AM

Thanks , it worked , but this is not what i wanted :

i don't need logical separation of pages to separate pages . I need that it will be actually seen (and not only in Print Preview) . I just need to enlarge the page height from 22'' to something larger , and it dont allow me . And 22'' it's 2.5 normal pages . I don't understand the logic behind this....

Paula222 · April 10th, 2006, 06:10 AM

I guess that there is no other way than the Tab Control.......

leehambly · April 12th, 2006, 09:26 AM

Paula,

Not sure I understand exactly.. but will have a go at helping!?

You have a FORM that you are displaying data on and also printing...
You want the data to spill from one page of the FORM on to "other instances" (ie: pages) of the same form, as the form is filled to the end?
So, am I right in thinking this form is a CONTINUOUS form?

I think this is going to be possible... but would reckon it is only possible with a class form and some quite intensive coding to get to that point... ie: to be able to know when the form has been filled.. but also it will need to identify things such as screen resolution, font size, list size (if you have any) etc, etc...

Some questions:

Why are you printing out a FORM?
Would a REPORT not be more suitable?
Are the form PAGES all, in principle, showing the same data? Or is the data on the PAGES of the FORM different? Basically, is the second page of the FORM there because the first page isnt big enough to hold all the data OR is it because the second page contains entirely different fields for the record...

Sorry, trying to understand the problem you have, and why you have it?