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.