Background
I have used MS editors and applications for years including Visual Studio and office products and got use to CTRL+Y being redo. In fact so use to it doing that that I use undo CTRL+Z multiple times to look back on what I had just done then CTRL+Y until I get to my last point which has become second nature... that was until I came to Access 2007's VBA editor which has CTRL+Y being cut line.
Now I understand that this has always been this way (and I'm sure is useful if your use to it) but I'm not and apparently am unable to correct my brain just for Access 2007 and keep losing my whole redo list by clicking it when I want to redo. :(
I have looked for a solution in help files, Google (other search engines are available I'm sure! ;)) and even on SO but alas I have only found other soles like me who keep wiping there redo chain and others shouting at them for not being able to just learn that's what it does. LOL I'm stuck in my ways and don't use VBA's editor often enough to adapt!
So my Question
Is it possible to ether:
* Remap the CTRL+Y shortcut key in Access 2007's VBA Code editor to Redo
* Disable the CTRL+Y shortcut key in Access 2007's VBA Code editor
Both of these would solve my problem of wiping the redo chain and losing any work I had done.