Changing Keyboard Keys 1

[jurgen]

Hi,

Does someone know how you can assign an other character to a key? The problem we have, is that we use Dutch-Belgian Keyboards, so our decimals are 256,66 in stead of 256.66
is it possible to assign in an Access UK version other characters, a . must be a , ?

Regards


Jurgen

 

[ghubbell]

Hello Jurgen,
I'm not sure if this shouldn't be handled in the "regional settings" of your computer, but here is a way on one form you can "switch the keys":

In the form design view and in the forms properties you will have to set "Key Preview" to Yes.

In the "On Key Press" in Visual Basic you would have like this:

Private Sub Form_KeyPress(KeyAscii As Integer)
Select Case KeyAscii
Case Asc(".&quot
KeyAscii = Asc(",&quot
Case Asc(",&quot
KeyAscii = Asc(".&quot
End Select
End Sub

I'm really not sure if this is what you would like, however I am sure it will give you some ideas! Best wishes,
Gord
ghubbell@total.net