Why when Im writing code and I hit the 'Space Bar' it jumps back a spot and turns red

[anoble1]

This has been going on for a while now. When I edit code or write new code in Ms Access, When I say like DoCmd.***
I can't even get the options to stay on the screen for more than 1 second, they go away and it backspaces and turns red cause it's incorrect. Also, when I say IF somthing right before or after I hit the S it reads IFSo....

It's so nerve racking, probably makes no sense. I will try and post some screenshots if you can see them.

It's when I start typing it backspaces and turns red and keeps doing it.

[MMcCarthy]

Simple answer is I have no idea :D

OK in the VB Editor go to tools - options.

Under the Editor tab make sure all the checkboxes are ticked.

BTW, what version of Access are you using.

[anoble1]

2007, it was doing it in 2003 as well. I wish I could explain my problem better.

[Stewart Ross]

I have had this occur when a short-duration On Timer event is set for an active form in the DB concerned. If you are editing a VBA module whilst the form concerned is active the On Timer event continually interrupts the VB Editor, giving the red text and apparent errors, and indeed stopping intellisense from working at all.

In my case the On Timer event was used to display a little clock on the main switchboard, updated each second. I eventually removed this 'helpful' feature to allow me to continue development work unhindered...

-Stewart

[colintis]

Stewart, so where can we stop the On Timer event thing? can you give us some instructions?

[MMcCarthy]

You need to find where the OnTimer event appears in your code, macro or has a command programmed directly into the event property.