I've been running a vb application I wrote for several months now.
Suddenly, when I run it, I get an error:
It's erroring on compile a simple "left" statement.
I go into the immediate panel typing ? Left("abcd",2) and get the same error. ? RIGHT("abcd",2) works fine
I notice, as I'm typing the command, the suggestion is wrong.
Troubleshooting:
I close my application, open a blank database, and it's fine. My access program isn't corrupted
So there is something in my application (just a bunch of vb scripts, tables, and queries) that is changing the format and meaning of the LEFT command. I've disabled my startup switchboard, done a compact and repair database, checked my form startup code. I'm lost.
Does this make sense to anybody?