This is an odd one... Even the guys at our help desk here and my Professor don't know what to make of it.

The LEFT(), RIGHT() and MID() functions are used to chop off little bits of strings as we all know...Normally when you are coding a function and you hit the '(' a tooltip pops up telling you exactly what the function needs to work.

I've had one instance where the RIGHT() function completely stopped working. In fact it caused a program of mine to crash. I was taking care of the App.path problem (wherein the APP.PATH method doesn't always return the final '\') and suddenly my program couldn't find any of my files. Now when I try to use LEFT() or RIGHT() the tool tip doesn't pop up (though it does on MID() )

I used this code in the SUB MAIN() with gstrPath as a public variable:
If Right(App.Path,1)<>"\" then
gstrPath=App.Path & "\"
Else
gstrPath=App.Path
End If

I've taken to using the MID() function instead of right or left and just starting either with position 1 or the LEN() of the string. But because MID can be a little unwieldy at times, does anyone know why this happened or how to fix it?

Help Desk guy thought it might have been a dll association that was missing, no dice there.

I even went as far as to reinstall VB6 and SP3 but it's still happening....Odd thing is that I have the same setup in work and in class and they're all doing the same thing. MID() works just fine, but RIGHT() and LEFT() do not.

Any advice?

Eiredrake