[AccessD] Key Preview Problem

I just threw a quick form together (in Access 2002). Set the property sheet
KeyPreview to True and then added this KeyDown event handler...

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    Select Case KeyCode
        Case vbKeyF6
            Text0.SetFocus
            KeyCode = 0
        Case vbKeyF7
            Text2.SetFocus
            KeyCode = 0
        Case vbKeyF8
            Text4.SetFocus
            KeyCode = 0
    End Select
End Sub

It works exactly as you'd hope, and there is no calling of the spellchecker
on any number of F7 keys.

If you are still having troubles then I would say you have a corrupt form.
Back up the application and then go through the usual  process for getting
rid of corruptions...

Decompile and if that does not work try importing everything into a new,
blank database.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Wednesday, March 15, 2006 6:13 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Key Preview Problem


Dear List:

I have a tab form with four tabs.  I want to set the focus in each tab 
by pressing the functions keys F5, F6, F7, F8.  The KeyDown event is coded:

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

    Select Case KeyCode
        Case 116
            Me.pgOrderNumber.SetFocus
            KeyCode = 0
        Case 117
            Me.pgReceiving.SetFocus
            KeyCode = 0
        Case 118
            Me.pgProcessing.SetFocus
            KeyCode = 0
        Case 119
            Me.pgShipping.SetFocus
            KeyCode = 0
    End Select
   
End Sub

The first time I press one of the four function keys it works.  Then, it 
quits.  (Like if I press F7 the first time is sets the focus to 
pgProcessing, the second time it invokes the spell checker.)

Does anyone know why this would happen?

MTIA

Rocky

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com