Solved

page break on a form access 2013

Posted on 2015-02-09
8
362 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
8 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 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 47

Expert Comment

by:Dale Fye (Access MVP)
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
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now