My Field Company and Town will not change to Upper case. Some fields do but a couple don't. Any fix or work around appreciated.

Is the fields read-only or virtual and what is the derivation?

Plain text field - Required and Indexed - derivation -   proper (cotown)    some other fields in the form work but at least two don't. 

Proper will only make the first letter Capital so: dAVE would be DAVE and dave would be Dave and DAVE would still be DAVE.

In these cases we need to see a sample that showcase the problem as anything else would just be guessing.

Any saved field will only be calculated when it is edited, so if you change the derivation after it is saved it will not be re-calculated.

Done all that but still doesn't work. Works on most fields but three it doesn't. 

OK! We love it when you guys think we are psychics but sorry, can’t do anything about it without seeing it so either you need to upload a sample that show it here, or you need to figure it out on your own ;-)

Here is a screen shot, full database is very large and sample wouldn't work as some fields it works on. See company town and postcode fields. 

Thanks for that, but the problem wasn't that I didn't belive you ;-)

Obviously if I try to replicate it, I don't get a problem...

So if you can't send anything, then you simply need to test.

Change the length of the field or something like that, so you trigger a TDF change. If there is something hanging then that should do it.

If the problem is historic, simply run a DQL that modify all the existing data.

modify records in YourTableName Company := proper(company) .