AnsweredAssumed Answered

Cannot remove formatting when entering text into fields

Question asked by BillDawes on Jul 1, 2014
Latest reply on Jul 1, 2014 by Fred(CH)

Summary

Cannot remove formatting when entering text into fields

Product

FileMaker Pro

Version

13.0v3

Operating system version

windows 8.1

Description of the issue

Since upgrading from FMP 10 to 13 it now imports formatting to fields whereas previously it just pasted text.

I have to remove the formatting manually which is painful.

I have tried following these steps but it changes the field name

Method 1: Prevent text from being formatted during data entry.

A field can be defined to make sure data is entered in a specific format, or within a certain range. To save time and ensure accuracy, you can set FileMaker Pro to automatically enter unformatted data in a text, number, date, time, and container fields. For example, field.

To set options for automatic data entry:

With the database open, choose File menu > Define > Database.
In the Define Database dialog box, click the Fields tab.
If your database contains more than one table, select the appropriate table from the Table list.
Select your text field from the list of existing fields, or define a new one, for example fieldA.
Click Options (or double-click the field name).
In the Options for Field dialog box, click the Auto-Enter tab and select the Calculated Value (or click Specify), then enter the following calculation.

TextFormatRemove(fieldA)

To make an auto-enter calculation self-modifying, leave the Do not replace existing value for field (if any) option unchecked.

Outcomes