?
Solved

Turn off page down/up navigation

Posted on 2013-12-31
6
Medium Priority
?
397 Views
Last Modified: 2013-12-31
Hello Experts
Does anyone know if page up/down navigation through records on a form can be turned off?  I want the user to use the navigation buttons I’ve provided on the form to navigate next and previous.  These buttons have code behind them that evaluate the data of the navigated to record and formats the text, hides or makes visible select data elements.  Or is there an “On Next Record” action that I can apply code to?  
Thank you
0
Comment
Question by:dhemple
  • 4
  • 2
6 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 39748530
In design View right-click your form and select Properties. Under the Format tab, change "Navigation Buttons" to No.

Flyster
0
 

Author Comment

by:dhemple
ID: 39748550
Thanks for your response Flyster, but changing "Navigation Buttons" to No does not stop navigation with [Page Up] or [Page Down] on user's key board.  Do you know of a way to prevent navigation as described?
0
 
LVL 22

Accepted Solution

by:
Flyster earned 1000 total points
ID: 39748563
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 22

Expert Comment

by:Flyster
ID: 39748743
Regarding the above code, put it in the On Key Down Event (Properties - Event Tab). If you use the code builder, the first and last lines will already be added.
0
 

Author Closing Comment

by:dhemple
ID: 39748748
Thank you for your help Flyster.  This is exactly what I was looking for.  Happy New Year!!
0
 
LVL 22

Expert Comment

by:Flyster
ID: 39748939
You're Welcome. And a Happy New Year to you too
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month7 days, 10 hours left to enroll

607 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