Can a Keyboard Shortcut be deactivated? 1

[punky001]

I have a user that forgets and uses the ctrl minus sign (-) on an Access 2007 form which deletes a record - which he doesn't want to do. He uses this in Excel 2007 and it zooms out.

Is there any way I can deactivate the Ctrl minus sign in Access?

 

[lameid]

Last time I trapped a keystroke with a macro was in Access 2003... Looks like MS keeps making it harder. Check out these links.

http://office.microsoft.com/en-us/a...by-using-a-keyboard-shortcut-HA010239111.aspx

http://www.utteraccess.com/forum/Au...8.html&pid=1958103&mode=threaded#entry1958103

 

[MazeWorX]

you can easily trap key board strokes in a versions of ms office. just google it

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[TheAceMan1]

How are ya punky001 . . .

I know its a little late but if not resolved perform the following:
[ol][li]Open the form in [blue]design view[/blue].[/li]
[li]Double-click the small square box at the end of the ruler to callup the [blue]properties window[/blue] for the form.[/li]
[li]Select the events tab. Scroll down to the [blue]Key Preview[/blue] event and make sure it saids [blue]Yes[/blue].[/li]
[li]In the [blue]On Key Down[/blue] event, copy/paste the following:

[blue]   If (Shift = acCtrlMask) And (KeyCode = 189) Then KeyCode = 0[/blue]

[/li]
[li][blue]Thats it ... save & perform your testing.[/blue][/li][/ol]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[punky001]

Thanks AceMan1!!! It works like a charm.....you got a star!