Billy Pang
tuxedoman888 at gmail.com
Wed Jun 13 18:25:37 CDT 2007
Hello: In MS Access 2003, I'm trying to emulate the key up / down behavior of a datasheet for a continuous form but something quirky is happening. Right now when the user presses the "down arrow" key, it moves down to the field directly below. But when when pressing the "up arrow" key, it moves up and to the left??? does anyone know why this is happening? Here are the steps to recreate this: 1) begin with a table with three fields and about 10 records. 2) create a new form (continuous form) with the three fields showing. 3) on form properties, turn on key preview. 4) implement the following: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyDown Then DoCmd.GoToRecord , , acNext '<-- this moves cursor down perfectly End If End Sub Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyUp Then DoCmd.GoToRecord , , acPrevious ' <-- this moves cursor up and to the left??? End If End Sub 5) go to form view. key down several times (works according to plan!) 6) key up several times (it does not go up directly; cursor goes up and to the left). thanks in advance, Billy -- Billy Pang http://dbnotes.blogspot.com/ "Once the game is over, the King and the pawn go back in the same box." - Italian proverb