formatting names (upper and lower case) (2000)

Topic

New Reply

I can’t find any reference in the books I have, but is there a function that will format a text field so that the first character is upper case and the others lower?

The data we have comes from a mainframe, and all names are in upper case. I’d like to format them to the proper case. I know I can use the left(), but thought there might be something that would do it smarter.

Thanks for any help.

Reply | Quote

Replies

You can use the StrConv( ) function with the vbProperCase conversion constant. This will capitalize the first letter of each word, while making all other letters lower case. Use like this:
[Namefield] = StrConv( [Namefield], vbProperCase)

Reply | Quote

That’s exactly what I needed. Thanks so much!

Reply | Quote

Not sure if this is what your looking for but check it out:
http://oak.cats.ohiou.edu/~andersoj/inputmasks.html

Reply | Quote

I have a subroutine that is in a module that I have modified to do this. After bringing data down from our AS/400 I use the routine to convert names and addresses to upper/lower case. I have modified it to handle cases such as McBride, etc… Let me know if you are interested in getting it.

Reply | Quote