Why Does it Change the Case of Variables?

[Rawb]

Simply put, the Visual basic Editor is randomly deciding to change the case of my variable names!

For example: If I type "strSONo" as a variable name (for "Sales Order Number"), the editor will change that to "strSoNo" as soon as I move off the line!

How do I stop this!!?!

And before you ask: No, I don't have it declared or used anywhere else. This is a brand new variable that I'm declaring and using for the first time (in this Module).

Yes, I've had other variables with similar names (in other Modules) that don't get changed.

Yes, I've tried turning off "Auto Syntax Check" in the editor Options.

No, I haven't been able to figure out any rhyme or reason as to when it decides to do this: Sometimes it will change a variable name on me, and sometimes it won't!

[RuralGuy]

Have you tried going from the Database window to:
Tools>AutoCorrect Options...
...and playing a bit?

[Rawb]

Apparently the AutoCorrect Options menu wasn't introduced until sometime after Access 2000 :/

Unfortunately, I'm forced to continue using Access 2000 because some of our workstations are pre-Win2k (Ugh, I know)!

Additionally, the company won't shell out for anything new when what we have still works

Also, in playing around (read: screaming threats and curses at my computer), I found that it SEEMS to be that I haven't Dim'd the variable yet. If I make sure to Dim a new variable it doesn't appear to have any problems with my case selections.

[RuralGuy]

That is always a good practice in any event!

[Rawb]

Well, yeah. . .

Sometimes though, I get stuck on something and end up making changes that need a new variable to work. So I just make the new variable and continue with coding.

Then, when I've got everything how I want it, I add an "Option Explicit" to the beginning of my module and compile/Dim stuff until it works >.>

[RuralGuy]

Hmm...may have to alter your style just a bit then.