>>>>Randy,
>>>>
>>>>Just curious, but why don't you want to use PROPER()?
>>>>
>>>>~~Bonnie
>>>>
>>>>
>>>>>I don't want to use the command, proper, but I do want my first letter capitalize. I feel like I'm writing to much code for this, give me some ideals.
>>>>>
>>>>>Thanks, Randy
>>>
>>>Names with McC would turn out to be Mcc.....
>>
>>Randy,
>>
>>I'm not sure if you've solved this yet but I use code in the interactive change method that just checks for the previous character being a space (or whatever you want) and if it is converts it. Because you are only ever checking the last character if the user types on they can then go back and override your conversion.
>>
>>HTH
>
>Good point, I'm converting the first char to caps. My first name and last name are seperate fields.

Hi Randy

Sorry if I'm a bit late on this one, but Paul Maskens and I published details of a data-driven class that handles the issue by allowing you to define special handling for particular words in a table. Checl out the article: "A Case in Point" in the July 2001 issue of FoxTalk (you can get back issues and downloads from www.pinnaclepublishing.com)