Joeclueless
Technical User
Is there a way to use an expression in VBA to change CAPS to Title Case?
I have the same issue as thread219-915762 although in VBA environment...
I'm trying to find something like this:
LCase ([NAME])
I've tried this:
Left( [NAME_ALF] , 1) & LCASE (Mid([NAME_ALF] ,2,20))
But that doesnt allow for multiple words??
Any Ideas??
Thanks again!
Joe
I have the same issue as thread219-915762 although in VBA environment...
I'm trying to find something like this:
LCase ([NAME])
I've tried this:
Left( [NAME_ALF] , 1) & LCASE (Mid([NAME_ALF] ,2,20))
But that doesnt allow for multiple words??
Any Ideas??
Thanks again!
Joe