2 Replies Latest reply on Nov 2, 2010 4:12 AM by GESY

    Text Field Filtering



      Text Field Filtering


      Hello folks, is there a way to make a single line text field, so it will be only a

      single line, and will not keep adding rows no matter what ?

      Also, is there a way to limit how many characters a person can enter on a text field ?


      Thanks        Gesy

        • 1. Re: Text Field Filtering

          You can limit the number of characters fairly easily:

          Enter Manage | Database | Fields, find your field's defintion and double click it.

          On the validation tab, you can enter a calculation such as Length(self) < 20 to limit the number of characters entered to 19 or fewer.

          Text entered into FileMaker can start a new line simply because the user typed in enough characters so that text wraps to a new line or it can be due to pressing the return key while entering text. You can disallow returns by either setting the field's behavior in the Inspector so that pressing return moves the cursor to the next field or by using this auto-enter calculation:

          Substitute ( self ; ¶ ; "" )

          Also clear the "Do not replace existing values..." check box.

          The auto-enter calculation option will remove returns even when the text is pasted into the field.

          • 2. Re: Text Field Filtering

            1000 OF THANKS !     Smile