On 2011 Feb 4, at 10:25, Rick O'Quinn wrote: > I've got a few fields that I need to keep to one line, but not one word. Most > are First Name, Last Name fields. I want to make sure users can't enter a > carriage return OR any other random characters, such as another name. BUT > entering 2 or more words (names) on one line is okay.... > > Is there an easier way?
I offload the responsibility onto the person doing the data entry by using (always) "Validate by Calculation" and this formula: PatternCount ( Author First; "¶" ) = 0 and Left ( Author First; 1 ) ≠ " " and Right ( Author First; 1 ) ≠ " " with the following error message on failure: "Author First" may not contain a return character or begin or end with a space. I use a similar validation in lots of other places where this kind of error is likely to crop up.
