I have a stanard database with Name, Address, Phone etc etc and I'm
having the following problem:

People cut and paste text in from their email and the internet, and
that formatted text goes into the fields of the database and doesn't
match the settings for the field.

I tried to insist on specific formatting using the calucated result
field, but then it's permanently formatted that way in every instance
of the text in question.

Is there some calculated result that REMOVES FORMATTING--kind of like
paste unformatted text so that the formatting will merely be the
formatting of the field they are pasting into?

Thanks.

David Averbach

From the docs:
=====================
TextFormatRemove(text)

Removes all text formatting from text in a single action. All fonts, styles,
font sizes, and font colors are removed from the specified text.
=====================
Use this function as part of an auto-enter calculation for the field.


"David Averbach" <dnaverbach (AT) mac (DOT) com> wrote

At least with FMP6, a script with the line :
Set Field(myfield, myfield)
gives plain text.
Remi-Noel

"Bill Marriott" <wjm (AT) wjm (DOT) org> a écrit dans le message de news:
n8udnRhQdt_qlqDYnZ2dnUVZ_vednZ2d (AT) comcast (DOT) com...

Remi,

FYI: The Set Field(myfield, myfield) technique no longer works in FileMaker
7 and later. Text formatting is preserved in calculations.

"Remi-Noel Menegaux" <rnmenegaux (AT) free (DOT) fr> wrote

Thanks, Bill, for this information.
Remi-Noel

"Bill Marriott" <wjm (AT) wjm (DOT) org> a écrit dans le message de news:
V-6dnYvzgvy13qDYnZ2dnUVZ_qmdnZ2d (AT) comcast (DOT) com...