In VBA when I type and use a space between words, my space automatically gets eliminated and all my words become one. What did I turn off or on to make VBA do this?

Post your code, more details and a sample.

____________________________
Real Programmer can count up to 1024 on his fingers

it is happening with all my code example
I type the following

dim street as string

as I type it automatically takes spaces away like below

dimstreetasstring

Or when I use my first " suddenly I see"" and I can't seem to stop it from automatically putting in the second one.

It's amazing, I've never seen anything like it!

It makes me thinking to any virus/worm/backdoor/netbus. Did you check your pc for it? (of course you did...) Anyway, it would behave this way with every text editor you work in, not only in Access VBA editor (but why not only into Access IDE?)...

And it makes me wonder about my keyboard driver, but it should be a standard Windows driver for sure. (is your keyboard clean from dust, particularily under the spacebar key?...)

And when does it remove the spaces? When you press Return to move on the new line, I guess, isn't it? If so, and if your keyboard works properly into other text editors, try completely remove and reinstall MSAccess. Maybe one library of it is corrupted at the moment.

In fact, if you type a double quote char, in order to enclose a string value within a couple of double quotes, there's no need to type the second one, as it's put automatically as you move on the next line. This is the normal VB editor behaviour. The strange thing is that it happens to you while you are still typing. It seems like it moves on the next line and then suddenly return back on the line you're typing in. If this would be the case, it looks like a trojan behaviour.

Well I'm aware I'm not that useful, sorry. Hope I gave you some reflection points to start.


____________________________
Real Programmer can count up to 1024 on his fingers

Virus protection up to date and on scheduled scan (sunday nights) But I did run again to make sure - no virus found.

Keyboard has been with pc for over a year and many projects - did clean it up a bit though

I'm going to try the tip on reinstall

very strange and I have never seen it before either
Thanks for the tips

Just to update I found my problem. I have a timer running a form that will automatically shut down the program if not active for a certain time period. (this eliminates user license issues with ODBCs) The form is hidden upon open and if not closed will cause the wierd vba typing. I close it on open when making changes and everything is normal.