I tried out what you posted and it seemed to work fine for me. I made a new text field, pasted in the formula you provided into an Auto-enter calc, deselected the 'replace field contents' option. I then made a new layout, put the field as a simple edit field on the layout. When I entered "fred flintstone" it auto-converted the entry to "Fred Flintstone".
Is there something else in the calculation definition window, perhaps? Could you post a picture of that, too?
What about on the layout itself? Are there script triggers on the field? Is the correct field on the layout? (Doesn't hurt to ask. ) Are you viewing this through a portal?
Thank I think if found the problem.
I thought i was gong crazy!
So what did you find?
I have to say thanks for mentioning the function, Proper(). I didn't know it existed before - I had to go look it up.
A couple of points on this one:
1. you shouldn't need the textformatremove part; Just Proper ( self ) should work.
2. you will need to address the question of variations. Bill O'Neil will get cross if his name is constantly altered to Bill O'neil.
TextFormatRemove ( ) may be needed if users are constantly pasting text in from other programs and you want to, say, remove the formatting.
Yes, we do have users who like to paste data into fields hence why I use extFormatRemove ( )
Thanks, I'm not too worried about the O'Neil's etc This database is just quickly captures Work Health and Safety KPI's from a limited number of contractors which is linked to my main database.
I just wanted to stop CAP TYPING etc
Thanks for your reply.