The expression | you entered as the event property...

[rob_levy]

Hi all,

I get the following error in the circumstances which follow:

The expression * you entered as the event property setting produced the following error: Syntax error

Circumstances:
I am in the module of a form which is in Form view (as opposed to Design view). I have got to this state by setting a break point or debugging an error.

I make a change to the code (can sometimes be extremely small and insignificant) and save the form.

When I switch back to the form I get the error where * is the name of whichever event should have fired when the form came to the front or when I try to close it.
e.g. On Activate, On Click, On Close, On MouseMove
The same type of errors also come up for the form from which the erroring form was opened.

When I close and reopen these forms, all is completely fine.

This is only a small irritation but it would be good to know I'm not the only one suffering from this.

I'm on Access 97 SR-2, Windows 2000

Your thoughts, as always, are extremely welcome.

Thanks,
Rob

 

[rsmonkey]

I would deffinately recommend and upgrade to at least Access 2000 as 1997 is pretty outdated now. The problem sounds like Access is having difficulty reading edited code when the form is open hence having to close & reopen to refresh.

 

[RuralGuy]

It is a good practice with Access to *not* make any changes to your code while the debugger is running. AFAIK this is true up through the latest version ac2007.