August 12, 200520 yr 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
August 13, 200520 yr 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.
Create an account or sign in to comment