Stop VB Editor from auto-correcting

[DubCap01]

Hi all,



I am getting infuriated with MS Access 2010, as I cannot seem to get it to stop auto-correcting whilst I type in the VB editor screen

Here's an instance.

DoCmd.SelectObject actable,

And..... when I press the space bar to start typing "TblWhatever" as the next part, the cursor jumps back to the comma at the end of the sentence, forcing me to again hit the spacebar to go to the next part of the string and type it REALLY quickly to stop it auto-correcting and jumping back there again!! It's a real-time visual thing, so I cannot post any examples.

I have tried every combination in the VBA - Tools - Options, but I cannot get it to do what I want.

Does anyone know if this is Windows 7 or MS Access, and/or how I can stop it from happening???

thanks in anticipation
Pete

[Missinglinq]

Haven't come across this, before, and can't duplicate it, in v2007, but you don't need to go through the 'hit the spacebar to go to the next part of the string and type it REALLY quickly to stop it auto-correcting and jumping back there again' hucklebuck! You can simply continue typing and when you move off of the line of code the Access Gnomes will automatically insert the spaces, so

DoCmd.SelectObject actable,"TblWhatever"

will become

DoCmd.SelectObject actable, "TblWhatever"

with no effort on your part except to go to another line.

Linq ;0)>

[June7]

Also not familiar with this behavior and can't replicate in A2010.

Corrections do not occur until hit Enter.

[DubCap01]

Thanks for the replies everyone, it is something that is hard to explain without a visual - and I am not going to create a flash movie so you all can see, but nothing is helping!

So I shall close it as solved and carry on infuriated!

Pete

[apc0243]

I've had the same problem before. I couldn't get it to stop, but closing the visual basic editor sometimes fixes it. Other times I just close the whole database and try again. This usually fixes it!

Good luck!

[DubCap01]

well folks, I just found out why my VBA editor auto-deletes the spacebar nudge, and it's so simple it's silly!
I have a form open with an OnTimer event set to 1000, so every second, the form ticks over another 'second' on the virtual clock, and it resets my VBA editor timing - causing the auto-delete.
I changed the other form's timer to 60000 (1 minute), and the problem disappeared

Thanks for everyone's input - broadens the knowledgebase eh?