When you export the text, you should find an option to use the layout's formatting to format the exported text.
If you want to change the actual data, add an auto-enter calculation to the field's definition:
Proper ( Self )
and clear the "do not replace existing values" option.
Since this change will only apply to new records and old records when the field is edited, you can use Replace Field Contents with the Proper function to update all existing records.
Thanks for the help.
Have never tried that one before but it will work a treat I think. Not tried it on a Postcode yet.
Quita a good way to do it too, it wil;l change that data on entry and store it that way.