Text Fields with Carriage return

[Scott Pon]

I got a problem with people entering Carriage returns in text fields. Like in an e-mail field, someone presses [enter] but it creates a 2nd line, so they re-enter the e-mail address.

Now when I do an export it has:

[email protected][][email protected] (the [] is a box)

Sifting through 2000 e-mails looking for this is tedious. Is there something in layouts/field formats that can prevent a carriage return to be entered? Or is it something that is controlled in Define Field?

Thanks in advance.

FM Version 5, windows 2000

[-Queue-]

In Define Fields, validate your fields using a calculation of

not PatternCount( fieldName, "¶" )

or

not Position( fieldName, "¶", 1, 1 )

for fields which can contain a lot of data.