Page Break Not Working

access2010

Registered User.
Local time
Yesterday, 16:51
Joined
Dec 26, 2009
Messages
1,115
I have a form with a sub form
The sub form is set for Continuous Forms
I have placed a Page Break in the form footer, but the page down function does not work.

Could I please receive a suggestion as to what I am doing wrong?

Thank you.
Nicole
 
What page down function? Do you have buttons on form with code to navigate records by page? This can be done without PageBreak. However, only method I can find uses: SendKeys "{PGDN}".

Post your code.
 
Last edited:
page down should work - but the subform needs to have the focus

also not sure what a page break would be on a form - it's a report control
 
Page breaks only make sense for a report. What do you expect to happen?
 
What page down function? Do you have buttons on form with code to navigate records by page? This can be done without PageBreak. However, only method I can find uses: SendKeys "{PGDN}".

Post your code.
We are using Access 2003 and in our toolbar there is a function = PageBreak = ......... =

Thank you.
Nicole
 
Please file attached a screen shot of the, PageBreak (not Page Down) that is not working.

Your assistance is appreciated.
Crystal
 

Attachments

I used a page break in a office 2k program for a wizard
Just found this code for two buttons

Code:
Private Sub CmdBack_Click()
  If [PageNum] = 4 Then
    Me![CmdBack].Enabled = True
    Me![CmdNext].Enabled = True
    DoCmd.GoToControl P3.Name
    DoCmd.GoToPage 3
    Me![CmdFinnish].Enabled = False
    [PageNum] = 3
    Exit Sub
  End If
  If [PageNum] = 3 Then
    Me![CmdBack].Enabled = True
    Me![CmdNext].Enabled = True
    DoCmd.GoToControl P2.Name
    DoCmd.GoToPage 2
    Me![CmdFinnish].Enabled = False
    [PageNum] = 2
    Exit Sub
  End If
  If [PageNum] = 2 Then
    DoCmd.GoToControl P2.Name
    Me![CmdBack].Enabled = False
    Me![CmdNext].Enabled = True
    DoCmd.GoToPage 1
    [PageNum] = 1
    Exit Sub
  End If
  If [PageNum] = 1 Then
  End If

End Sub


Private Sub CmdNext_Click()
  If [PageNum] = 1 Then
    Me![CmdBack].Enabled = True
    Me![CmdNext].Enabled = True
    DoCmd.GoToControl P2.Name
    DoCmd.GoToPage 2
    [TaskName].SetFocus
    [PageNum] = 2
    Exit Sub
  End If
  If [PageNum] = 2 Then
    DoCmd.GoToControl P3.Name
    Me![CmdBack].Enabled = True
    Me![CmdNext].Enabled = IsNull(chkRemind)
    Me![CmdFinnish].Enabled = Not IsNull(chkRemind)
    DoCmd.GoToPage 3
    [PageNum] = 3
    Exit Sub
  End If
  If [PageNum] = 3 Then
    DoCmd.GoToControl P4.Name
    Me![CmdBack].Enabled = True
    Me![CmdNext].Enabled = False
    Me![CmdFinnish].Enabled = True
    DoCmd.GoToPage 4
    [PageNum] = 4
    Exit Sub
  End If
  If [PageNum] = 4 Then
  End If

End Sub
 
You never answered what do you want to happen? Forms don't paginate so a page break wouldn't be actuated. I'm sure the control is only there to support using a form as a report.
 
1603774921269.png


Hello, we are still trying to find out why the above = PageBreak248 = does not want to work in Access 2003 and I would appreciate your assistance with an answer.

Thank you.
Crystal
 

Attachments

Reviewing this thread, I am still unsure as to what you expect to happen. When you say "Page Break" doesn't work, I am not doubting you - but I don't know what you expected it to do (that it didn't do.) So I'm going to ask what sounds like a dumb question, but I'm trying to understand your goal. How do you know that the Page Break didn't work? What specifically is the symptom? What did you see that was unexpected? What did you NOT see that WAS expected?
 
Thank you for your note.
We would like to push the PAGE DOWN key and then go to the area below the [ .... ] page break

Thank you.
Nicole
 
the usual placement of PageBreak control is in the Detail Section when your Detail section is Long.
so adding this control to that section, you can use the PageDown/Up key to see the next Area on the
detail section.
 
A page break control is not necessary for Page Down/Up keys to work.

OP appears to be trying to use page break control for a purpose it is not intended.
 
as previously advised pagebreak only works when printing a form, not when viewing the form
 
Forms don't "break". Reports "break" but only if you define groups.

If you want a form to "break", you can partially achieve that by using a main form with a subform. For example, you can have a main form bound to the class table and it will show information about the class such as where it meets, when it meets, and its syllabus. The subform can be bound to the ClassRoster and he can display the students who are taking the class.
 
Reviewing this thread, I am still unsure as to what you expect to happen. When you say "Page Break" doesn't work, I am not doubting you - but I don't know what you expected it to do (that it didn't do.) So I'm going to ask what sounds like a dumb question, but I'm trying to understand your goal. How do you know that the Page Break didn't work? What specifically is the symptom? What did you see that was unexpected? What did you NOT see that WAS expected?
Thank you for your note.
The 2003 Access Form is comprised of =Form Header = Details = Form Footer =
There is the= PageBreak ... = on the Form Footer
We had expected to be able to read the comments on the bottom of the form footer below the = PageBreak ... = that we could reach with the "Page Down" key

Thank you.
Crystal
 
i don't think you will be needing a PageBreak control on the form footer.
the Form footer is Visible every time (at full height).
the only section that will adjust the size is the Detail section.
 
unless the form window is taller than the screen/workspace it is in so the footer is effectively below the bottom of the screen/workspace
 
why not use a Pop-up Form to show the content of the textbox in footer
just as in this sample.
 

Attachments

I have a form with a sub form
The sub form is set for Continuous Forms
I have placed a Page Break in the form footer, but the page down function does not work.

Good day
>try to work with subform property sheet
scroll bars = Both
>page down would even work if the area of subform will be filled of data
if you have only two rows data that remains space on subform surface then might page down is still disabled
 
Last edited:

Users who are viewing this thread

Back
Top Bottom