center mouse scrolling records 1

[ErnNJ]

Is there a way to stop the scroll button from scrolling through active records on a form? I have a form with fields bound to a table that I want to use for updating only one record at a time. I took off the navigation buttons and the scroll button still scrolls through the records.

 

[needadvice]

You have to disable the keys that cause the scrolling. here is an example of the code to do this. Private Sub Extension_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
' If user presses TAB, ENTER, PAGE UP, PAGE DOWN
Case 13, 9, 33, 34
' Disable the keystroke by setting it to 0
KeyCode = 0
Case Else
Debug.Print KeyCode, Shift
End Select
End Sub

 

[Laois]

You cannot do with access alone. Check out this Microsoft KB.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q308636