access97 - auto syntax problem since vba critical upgrade

[Roger]

running on XP pro
adding vba code, I want to type in 'X = "good"'
when I type the 'X', and a 'space', if I wait a second, the cursor
automatically moves back over the 'space'

when I type the 'X', a 'space' and the '=', if I wait a second, I get
just 'X=' in red (like when you've got a syntax error)

when I quickly type in 'X', '=' and '"', after a second I get 'X = ""'
(making it hard to enter a string)

I created a new MDB and imported everything and the problem went away
for two hours, now it's back

I've compacted and repaired, no luck

I've unchecked all the coding options under tools->options->Module, no
luck
(they're normally all checked except 'keep debug window on top')

this happened a few times in the past 6 months and just restarting the
mdb fixed the problem

but it's happened three times in the past two days, after installing
the last critical XP upgrade and the office upgrade, ms-37 - vba patch

has anyone seen this ? or does anyone know how to rectify the problem
?

[Marc]

Re: access97 - auto syntax problem since vba critical upgrade

lesperancer@nat pro.com (Roger) wrote in message news:<8c7a509f. 0309051355.def5 2a3@posting.goo gle.com>...[color=blue]
> running on XP pro
> adding vba code, I want to type in 'X = "good"'
> when I type the 'X', and a 'space', if I wait a second, the cursor
> automatically moves back over the 'space'
>
> when I type the 'X', a 'space' and the '=', if I wait a second, I get
> just 'X=' in red (like when you've got a syntax error)
>
> when I quickly type in 'X', '=' and '"', after a second I get 'X = ""'
> (making it hard to enter a string)
>
> I created a new MDB and imported everything and the problem went away
> for two hours, now it's back
>
> I've compacted and repaired, no luck
>
> I've unchecked all the coding options under tools->options->Module, no
> luck
> (they're normally all checked except 'keep debug window on top')
>
> this happened a few times in the past 6 months and just restarting the
> mdb fixed the problem
>
> but it's happened three times in the past two days, after installing
> the last critical XP upgrade and the office upgrade, ms-37 - vba patch
>
> has anyone seen this ? or does anyone know how to rectify the problem
> ?[/color]


It looks to me as a form of spontaneous cursor-movement problem. You
could simlate it just by using the right and left cursor-keys. I don't
think it is an office-defect.
Look for possible hardware-problems (bad keyboard) or
software-initiated cursor-problems. Think of running keyboard-macro's,
remote-control-software on your PC or keyboard-driver problems (some
keyboards have special features and dito drivers). Eventually some
other ill-behaving software like a virus or hacker-tool could be
responsible for these spontaneous key-movements. In any case try
running the same database on another machine to be sure if it is
office- or PC-related.

Marc
Marc