Reassign the Function Keys (F12, etc.)

[simiCop]

I'm writing a computer aided dispatching program targeted at security companies. While within certain text box fields, I want to assign the Function keys (F2, F6, etc.) to trigger a search, exit, ...whatever.

This works when I use ASCII character codes with Shift+1 and such, but I can't find an ASCII code for the function keys, nor can I get the code to decode. Additionally, I notice that MS Access uses the function keys to trigger its own shortcuts.

Is there a way I can dissociate the function keys from Access and assign my own functions to them?

Thanks,
Chris Tucker (NO, not that one)

[missinglinq]

VBA has constants for all keys, which makes it easy! Just use them like this:

Private Sub YourTextBox_KeyDown(KeyCode As Integer, Shift As Integer)
    Select Case KeyCode
 
         Case vbKeyF3
         KeyCode = 0
         MsgBox "F3 Pressed"
 
         Case vbKeyF4
         KeyCode = 0
         MsgBox "F4 Pressed"
 
         Case vbKeyF5
         KeyCode = 0
         MsgBox "F5 Pressed"
 
    End Select
 End Sub
 

Just replace the message boxes with your code of choice. The line

KeyCode = 0

is necessary to suppress Access' native uses for some of these keys. F7, for example, normally invokes SpellChecking and F12 normally invokes Save As. These keys will still work in their normal way except when they're pressed while in the given text box.

Welcome to TheScripts!

Linq ;0)>