Uppercase Property

[hicksi]

"Something" in my VBA has changed the case of DESCRIPTION in my code for standard properties.
Ie, my code that formats an error now contains Err.DESCRIPTION.

I don't know how or why this has occurred, but is a way to correct it. Going through and removing all instances, closing and re-opening and uncommenting the removed code simply changes back to the Uppercase.

It's not a CRITICAL problem, but I share code containing this between projects, and don't want it propagating through other projects.

Is there a way to "fix" this problem, possibly by removing and reinstating a reference or control?

 

[DanteAmor]

That happens when, on some occasion, you declared a variable called DESCRIPTION with capital letters. Maybe in some module you have it that way.
Look for that statement.
If you can't find it, simply in a module, in a macro, declare any variable as Description
For examle:

Dim Description As String

And that's it, the name will be the first capital letter again.

In the future, try not to use reserved words in variable declarations.

 

[hicksi]

Yep. You are right. I have no idea when the variable got created. It IS a text value that I am testing, so maybe at some time the quote-marks surrounding it were interpreted as a variable name.

Anyway THANKS.