Return to FileMaker.com
How to Standardize Format of Text in Browse mode
Users are copying and pasting text from different places into our Filemaker database.
They are not hitting Ctrl Z so the record is saving the text in many different formats.
How do I make sure all text looks the same after a user pastes the text from different places?
Add the following auto-enter calculation in Field Options for each such text field:
TextFormatRemove ( self )
Clear the "do not replace existing values" check box.
If you already have an auto enter calculation specified, enclose it in this function call:
TextFormatRemove ( put existing calc here )
Retrieving data ...