Flexibility in scrolling through continuous forms (no scroll bars)?

[Richard Hollenbeck]

Is there a way in Access that I could make it so that the end user could
scroll up and down, or right and left, depending on the arrow keys
depressed? In form view, instead of going left to right through each
record, just scroll down a column, or to the right, or to the left, or
whatever?

Thanks.

Rich Hollenbeck

[Albert D. Kallal]

In general, the left/right arrows do work just fine, but the up down don't
work (as you mentioned).

I just as a regulate thing nearly *always* paste the following code into my
continues form, and they function just like a spread sheet.

Also, make sure you set the forms keypreview = yes

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)

' key hand

Select Case KeyCode

Case vbKeyEscape
KeyCode = 0
DoCmd.Close

Case vbKeyUp
KeyCode = 0
On Error Resume Next
DoCmd.GoToRecord acActiveDataObject, , acPrevious

Case vbKeyDown
KeyCode = 0
On Error Resume Next
DoCmd.GoToRecord acActiveDataObject, , acNext

Case vbKeyReturn
If IsNull(Me.ID) = False Then
KeyCode = 0
Call EditMain
End If

End Select

End Sub

You of course can remove the Esc key, and the Enter key code I have
above....

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.attcanada.net/~kallal.msn

[Wayne Morgan]

One option, Tools|Options|Keyboard tab. Set "Move after Enter" to Next
Record. This will cause you to go to the next record when Enter is pressed.
Page Up/Page Down will move you a page of records at a time. Another option
for moving one record at a time when up/down arror are pressed is to set Key
Preview to On for the form and in the form's KeyDown event.

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyDown Then
DoCmd.GoToRecord , , acNext
End If
If KeyCode = vbKeyUp Then
DoCmd.GoToRecord , , acPrevious
End If
End Sub
--
Wayne Morgan
MS Access MVP
"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:a1****************@nwrddc01.gnilink.net...

Is there a way in Access that I could make it so that the end user could
scroll up and down, or right and left, depending on the arrow keys
depressed? In form view, instead of going left to right through each
record, just scroll down a column, or to the right, or to the left, or
whatever?

Thanks.

Rich Hollenbeck