Autocorrect - How to kill this monster.

[raskew]

On any posting I've made where code is included, you'll see something like:

Dim db As DATABASE

...'Database' is going to be 'DATABASE' regardless of what I do (short of modifying the code once it's in the forum editor). Not really an earth-shattering problem, but it's been an annoyance for years (I'm not a fan of all-Caps--I'm gonna scream at you-- in any situation) and just can't seem to track down the cause. 'Database' is the only word aflicted with the all-caps disease.

Have gyrated over every possible AutoCorrect setting I can find. All insight greatfully accepted.

Thanks,

Bob

 

[TheAceMan1]

Testing . . .

[blue]   Dim db As Database[/blue]

   Dim db As Database

Database
database

See Ya! . . . . . .

 

[raskew]

Ace -

Sorry. Maybe I didn't explain it well enough:

I input "Dim db as Database"

...it comes back in the module as:

"Dim db as DATABASE"

...that's the problem.

If I attempt to edit the procedure, changing

"Dim db as DATABASE" to

"Dim db as DataBase"

it responds with

"Dim db as DATABASE"

... that's the problem I'm trying to overcome.

Bob

 

[TheAceMan1]

raskew . . . .

Nooo . . . my fault . . . sometimes I wonder if I have an eye to see with! ;-)

[ol][li]What Version Access.[/li]
[Li]Does it happen in any module?[/li]
[li]How about a module in another DB.?[/li][/ol]

See Ya! . . . . . .

 

[Eupher]

Heh, seen this one before. See this thread: thread705-652659

But the quick and dirty solution is to declare a variable named "Database" - then recompile, save, then remove the declaration, recompile and save again. That should get things back to normal.

Ken S.

 

[raskew]

Eupher / Aceman1:

Using A97. This condition exists across the board. With absolutely no effort on my part, have been able to infect other computers with the same problem. We're not talking about 'a database' -- it's more on the magnitude of 'several hundred databases'.

Eupher - Don't pretend to understand why the recompile / save solution works, but it indeed appears to have solved the problem. Your solution is a definite keeper!

Many thanks!!

Bob