App.EXEName and App.Path returning all UPPER CASE in EXE

[JoeyCode]

Hey Everybody,

I'm encountering an annoying problem with App.Path and App.EXEName. It seems that when in the development environment, these values are in the correct case, but when running from a compiled EXE, these values are suddenly all UPPER CASE. For instance, if my application is located here:

"C:\Stuff\WaCkY\Location"

In the development environment, App.Path returns:

"C:\Stuff\WaCkY\Location"

But after compiling an EXE and running that, App.Path now returns:

"C:\STUFF\WACKY\LOCATION"

Things still work (as long as you allow for the difference when doing comparisions), but for display purposes this is ugly and inaccurate. Does anyone know why this happens and/or how to make it work properly?

Thanks,
-JoeyCode

this happens with me too.
in the vbIDE it works fine, all the letters are the correct case, but stand alone, the letters are all uppercase...
this is really odd...
or maybe its not, i have never had to use app.path very much.. so I am not sure if its supposed to be this way..

[HeSaidJoe]

not the same problem but the same situtation
using App.Path when comparing to paths stored in a database I have found a similar problem. the App.Path returned all
lowercase while the database showes mixed case (correct).
to get around it I use
Option TextCompare
this allowed the compare to just compare text regardless of the case.

Another option was to use
LowerCase or UpperCase against both sides of the comparison.

[mattbrown]

You can use the LCase$() and UCase$() functions to convert to lowercase and UPPERCASE respectively.

I think there is also a function that can convert To Sentence Case (First Letter Capitalised) as well but I can't remember what it is offhand.

Regards

[Edneeis]

You can convert things to lowercase, uppercase, propercase, and some other stuff like so:

StrConv(App.path, vbProperCase)