hi all,can you help please,
i have a textbox called "name", what i am trying to do is have lowercase on first/second names in the textbox except the last word (surname)this i want in uppercase any ideas please
Hello bigmac, first things first. 1. Name - A very bad Field/Control name. Change it.
2. Normally FirstName and Surnames are stored separately, I think that is not the same in your case?
If they are not separate, then you need the combination of InStrRev, UCase functions to get this sorted.
