Probably a number of ways to do this,  I use A'97, ran a test in the keydown
event to determine the keycode of each arrow ...

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
MsgBox Str(KeyCode)
End Sub

Then enter that code for each Select Case statement, I just tested for the
right arrow key and it worked fine even when editing a field.  I don't know
if it is necessary but I changed the KeyPreview property of the form to Yes
because it made sense ;)

Here it is for the right arrow key, add case statements for each of the other
arrow keys, Shift Tab will move backwards ...

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
   Case 39 'Right Arrow Key
       SendKeys "{TAB}"
End Select
End Sub

Hope this helps,
Roger

try tools->options->keyboard->arrow key behavior->next field

Gil, I was thinking about this a little more and if I was your user and I
made an error in typing I would want the arrow keys to act normally rather
than grabbing the mouse to move the curser.  So, here is a suggestion that
might work for what you want without 'arrow edit confusion'  ... ;-)

Keep the right and left arrow the way they were, use the up arrow to get out
of edit mode (probably save record will do that) and the down arrow to enter
edit mode - to keep things consistent (Sendkeys "{END}" or "{HOME}" should do
that).  So up arrow then right arrow will move to next field when in edit
mode.

Roger