Jan 23 2006, 09:41 PM
Hello UA Members,
I'm sure this is a easy question but i'm having a huge brain fart here.
On my form i have LastName, FirstName, MiddleName. I would like when the user inputs the names say in lower case that the name appear with the first letter only capitalized and the rest lower case. Any help would be appreciated, thanks in advance.
Jan 23 2006, 09:47 PM
You can ue the StrConv() function to do this but there are names that will be a problem such as O'Neil, McDonald and many others ...
I think r_cubed has a User Defined function in the Access COde Archive forum that is better suited for this task due to this problem ...
Search the Access Code Archive Forum here at UA for his solution ...
Jan 25 2006, 07:25 PM
I too have searched for this. In Access 95-97? I actually had this working in the form format by using ><. This automatically capitalised the leading character and made the rest lower case. Imagine my dismay to see that it doesn't work anymore =(
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here