String comparison

[AlexanderBB]

Having a problem dealing with sameness including casing with strings

Album is "LIVE!"
ThisRow!Title is "Live"
My first check fails

If StrComp(Album, UCase(ThisRow!Title), vbBinaryCompare) = 0 Then

so then tried

? Album <> UCase(ThisRow!Title)& "!"

But this failed too. Just wondering how others would handle this.

 

[AlexanderBB]

Weird... this is from the immediate window
? "HelLO" = Ucase("HelLO")
True

 

[Rick Rothstein]

And when I copy/paste it into my Immediate Window, it returns False for me. Weird indeed! I am not sure what to tell you now about that.

 

[AlexanderBB]

Aha, figured out why. Some of my VBA code I port between Excel and Access. Usually that's ok but Access has Option Compare Database giving different result.
In Excel I also get False. Whew! Sanity restored.