Title Caps with tweak

[pgsibson]

Hi Everyone

My coding skills are not great and I have seen many posts on creating Title Capitals. I would like to code for title caps except for words of 3 characters or less except if that word is the first word in the field.

Another problem I have is Capital initial letters for Names. This does not cover names such as "McCarthy" which end up as "Mccarthy"

Anyone like to help?

Regards

 

[ajetrumpet]

I would like to code for title caps except for words of 3 characters or less except if that word is the first word in the field.

I wonder if you could use the StrConv() function for this...

Another problem I have is Capital initial letters for Names. This does not cover names such as "McCarthy" which end up as "Mccarthy"

Unfortunately, programs don't have built-in lists of possible "Names". It does not know the difference between strings of "gibberish" characters and an actual person's name. The value is just a string, as far as the program is concerned. Sorry!

 

[Brianwarnock]

Hi Everyone

My coding skills are not great and I have seen many posts on creating Title Capitals. I would like to code for title caps except for words of 3 characters or less except if that word is the first word in the field.

Another problem I have is Capital initial letters for Names. This does not cover names such as "McCarthy" which end up as "Mccarthy"

Anyone like to help?

Regards

I'm sure one of the earlier threads contains code to handle the Mc, Mac and O' scenarios.
search under propercase.

Brian