Text formatting applies only to the object (typically, a field) on the layout where you apply it. It will not carry through the database to other areas. If you want to apply something like title case to the data itself, then you can use an auto-enter calculation that replaces the data, like this:
Proper ( Self )
Thank you for your answer, as I have fiddled with it a bit more i can see how what you are saying works through the database.