Hot Keys are TOO hot for me

[Sprocket]

I have a memo field that I use to keep running notes of interviews with my students. Whenever I see one of my students I want to be able to click into this field and use the hot-key combination CONTROL + ; (semi-colon) to enter the current date and then write up notes on the interview. Simple request....BUT

The prroblem is that the key next door i.e. CONTROL + ' (apostrohpe) if hit by mistake enters the field value from the previous record, which over-writes the notes for the current record. As my typing is not as accurate as I would like it to be this happens on an all too frequent basis. If I am looking at the screen at the time I usally notice this and correct it immediately with the undo command. However, I am more usually looking at the brief notes I have taken during the interview and, therefore, do not notice that I have just corrupted the record.

Is there anyway to either re-assign these keys to prevent accidental error or failing that to lock them out altogether.

Any suggestions greatfully received.

Sprocket

 

[WayneRyan]

Sprocket,

I had this from how to intercept the F1 key.
Put this sub in the form's key down event.
Set a breakpoint on the if statement
Hit control and ;
Examine KeyCode and Shift

' ***********************************
Private Sub Form_KeyDown(KeyCode As Integer, _
Shift As Integer)
Dim stAppName As String
If KeyCode = vbKeyF1 Then
'Do Nothing
End If
End Sub
' ***********************************

This isn't much, but didn't like the 0 response to your post.


hth,
Wayne

 

[Sprocket]

Many thanks for your suggestion Wayne - nice idea - and it does work to a limited extent.

The problem is that it trips out as soon as the Control key is pressed - well before the ; key is hit.

Obviously compoite keystrokes are not catered for.

However , I now know that the keycode for "Control" is 17 so if I can't be selective I can at least lock-out the possibility of error by preventing any Control combination for the memo field.


Cheers......... Sprocket.