I'm trying to create an auto calculate on a field that will remove the text format and Proper, but it duplicates the text in the field. What am I doing wrong?
(Proper ( Address )) & (TextFormatRemove(Address))
Thanks for your help!
Proper() isn't formatting, it changes the data. Text formatting is bold, italic and styles like UPPERCASE, SmallCaps etc.
Thanks so much!
Retrieving data ...