How i can set up a keystroke for an action MS ACCESS

Question

HELLO EVERYONE ,PLEASE HELP ME ON THISI HAVE A TEXT BOX IN A FORM. I WOULD LIKE TO ADD AND DELETE QUANTITY INSIDE THE SUBFORM BY THAT TEXT BOX.THIS IS WHAT I WANNA DO.ADD :I WILL INPUT A NUMBER FOR QTY AND PRESS "+" (RIGHT KEYPAD) .DELETE : I WILL INPUT A NUMBER FOR QTY AND PRESS " - "WHICH CODE I CAN USE TO ASSIGN THE ACTION FOR THE "+" AND "-" .THANKS ,EDWARD

daniel_pineault · Answer

Could you not use the key press event?https://docs.microsoft.com/en-us/office/vba/api/Access.Form.KeyPress

hohai610 · Answer

hi ,thank you for replyCan you show me a easy example for keypress event please ?Daniel_Pineault&nbsp;

george_hepworth · Answer

hohai610&nbsp;Here's an easy example. Create a procedure like this:Public Sub CaptureKeyPress(ByVal KeyANSI As String)&nbsp; &nbsp; &nbsp;MsgBox KeyANSIEnd Sub&nbsp;Use it like this:Private Sub TextYourControlNameGoesHere_KeyDown(KeyCode As Integer, Shift As Integer)&nbsp; &nbsp; Call CaptureKeyPress(KeyCode)End Sub

Forum Discussion

How i can set up a keystroke for an action MS ACCESS

Resources