Why not just an autoenter calc...


Trim ( Substitute ( Author First ; "¶" ; " " ) )


...and take care of it for them?
 



On Feb 4, 2011, at 3:24 PM, Richard S. Russell wrote:

> 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.

--
Jonathan Fletcher
FileMaker 9 & 10 Certified Developer

Fletcher Data Consulting
[log in to unmask]
http://www.fletcherdata.com
502-509-7137

Kentuckiana's FileMaker Users Group
Next meeting: February 22, 12:00 pm to 3:00-ish
Special Location! Special Program!
Info & RSVP: http://fmpug.com/scheduleMeetings.php
Listserv signup: http://fmpug.com/mailman/listinfo/louisville_fmpug.com
Blog: http://www.kyfmp.com