akaivyleaf
Programmer
Using PROPER in excel changes text to both upper and lower case. Capitalizes the first letter of the name and makes the rest lower case. . . Most of the formula's in Excel transfer over to Access but not this one. Any suggestions for getting text to convert to sentence case in Access? A column at a time or a table at a time.
This is as far as I have gotten with my formula and have drawn a blank.
Proper: Left(UCase([L_Name]),1) & LCase([L_Name])
This repeats the first character so that my result looks like this Bblair. I just need it to read Blair.
Thanks,
Sharon
This is as far as I have gotten with my formula and have drawn a blank.
Proper: Left(UCase([L_Name]),1) & LCase([L_Name])
This repeats the first character so that my result looks like this Bblair. I just need it to read Blair.
Thanks,
Sharon