Validation to force proper case (ie first letter Caps only) where a suburb name is entered.
How do I acheive this. eg SEVEN HILLS when entered is converted to Seven Hills.
Hi,
You could try this formula PROPER(), it would capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.