How to set up a macro to type keystrokes in module

[Dea]

When I code modules, each line of an strsql statement needs " & _
I want to set these three characters on a key stroke to type them where I
want to end the statement. I tried setting up a macro called autokeys using
the instructions within Access 2007, but It is just not working; then I went
down the Sendkeys route and read some posts where that isn't such a great
idea.
I want to use Cntrl + z (^z) to type " & _ when I press Ctrl and the letter z.
What's the correct way to do this?

 

[Steve Schapel]

Dea,

As far as I know, an AutoKeys macro (or any macro at all, for that matter),
is not applicable in the Visual Basic Editor. Basically, this functionality
is for use within forms.

I am sorry, I don't know how to do this, except to say that there are some
third-party keystroke automation available, so maybe you could experiment
with this.

For myself, I would be pretty confident that I have typed " & _ in code a
few more times than you have, and it has never bothered me.

 

[Dea]

I have only typed the " & _ 683 times (just kidding), but I was sorta charged
with finding the answer (if there was one).

Thanks much