Unfortunately, that code doesn't work! At least, it doesn't work for me in Access 2003. I pasted that code into a module, then in the immediate window I typed the following
?URLEncode("WTF? This is the test string that fails.")
and hit Enter. This is the result:
Notice how the letter "T" (upper or lower case, doesn't matter) is converted to %DE but - and this is the weirdest part - only
when followed by the letter "h" (again, upper or lower case doesn't matter)! It's absolutely bizarre! Can anyone explain this to me?