?
Solved

page break on a form access 2013

Posted on 2015-02-09
8
Medium Priority
?
414 Views
Last Modified: 2015-02-10
Hi EE
I have placed a page break on a form top half and bottom half. When I select the Page Down button the form moves to the bottom half but then is stuck there Page Up button does nothing. I have used page breaks before although a long time ago and from memory the page down and page up button did the trick. Is there any diffedrence with access 2013

chestera
0
Comment
Question by:chestera
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 40600368
Try setting the value of the "Cycle" property of the form differently, and see how that works. Page Breaks are not often used in Forms, so it's possible other settings are conflicting with that.
0
 

Author Comment

by:chestera
ID: 40600436
Scott McDaniel

Page breaks are usually for reports but I have a form that is to big for the screen and I can't reduce any further without loosing some information it's rather a complex form and thought a page break might be the solution. With a good screen resolution no problems but there are a few laptops in the mix with low resolution 1300 x ----. I will play around a see what happens. It's getting late here so will try again tomorrow

Alan
0
 
LVL 48

Expert Comment

by:Dale Fye
ID: 40600564
Generally, when you have more information on one form than will fit on the screen, the best solution is to use the tab control and split the data up using some logic to determine what goes on each tab.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 total points
ID: 40600657
Use the tab control as Dale Suggested.   much either then trying to page in the form (which I used to do).

The problem with page breaks is your still limit to 22" of vertical design surface, so depending on resolution, 3 or 4 pages is it.  

With a tab control, you can have a dozen without issue.

 But to answer your question, yes it should work.   In addition to what Scott said, make sure you don't have any code trying to "eat up" page down/up keystrokes in the form (look at the Keypreview event) to prevent the user from moving off the record.

Jim.
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 40600681
Page breaks can also be used in a form as an alternative to a tab control.  I tend to use the tab control more often though.  If you use page breaks, you can add buttons on your form to go to a particular page.  In the OnClick event of your button you would add this:
Me.GoToPage (2)
The above would of course take you to the 2nd page of your form.

Ron
0
 

Author Comment

by:chestera
ID: 40601572
Jim Dettman

Hi Jim

I used a blank form and inserted a page break and it worked so there is somthing on my form preventing it from working.
I am not familiar with the Tab control.

The form would be split int into two Top and bottom.

Alan
0
 

Author Comment

by:chestera
ID: 40601643
Jim Dettman

I understand tab control on a form. I thought you ment using the key Tab on keyboard some how. Early in the morning haven't had my coffee yet

Alan
0
 

Author Closing Comment

by:chestera
ID: 40602185
Thank you all for your information. I have used a Tab form
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question