Hi Rick,

You can edit this field's behavior and make it to use Return to go to next field. This may be inconvenient, if users need to search using this field and are accustomed to using Return to start the search. Alternatively you might add a trigger that works in Browse mode and 'eats' returns (checks if the symbol is carriage return and return False to skip it, else return True).

Kind regards,
--
Mikhail Edoshin
[log in to unmask]



On Feb 4, 2011, at 7:25 PM, 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.... examples
> 
> I want to prevent this:
> John¶ (carriage return)
> Jimmy
> 
> And this:
> John¶ (carriage return)
> 
> But I want to allow this:
> Mary Alice
> 
> After digging around in the text functions for awhile, I didn't find an "out of the box" solution, so I searched Brian Dunnings Custom Functions list but couldn't find what I was looking for. I'm sure it's there and I just didn't hit the right search parameters.
> 
> Anyway, so I came up with my own custom function that is working.... since I'm not too good at righting those, so I was thrilled it worked. It might be a bit over blown with checking for 10 carriage returns, but I figured somebody's keyboard might get stuck. I threw in the trim after I got everything working to also get rid of leading/trailing spaces. The function below works, but I was wondering, is there an easier way to figure the number of words someone might throw in there? Like a >1 function? I tried that: ["¶"&RightWords ( TrimField ; >1 ) ; ""] but obviously the syntax isn't right.
> 
> Is there an easier way?
> 
> 
> Trim (
> 
> Substitute ( TrimField ;
> 
> 
> ["¶"&RightWords ( TrimField ; 10 );""];
> 
> ["¶"&RightWords ( TrimField ; 9 );""];
> 
> ["¶"&RightWords ( TrimField ; 8 );""];
> 
> ["¶"&RightWords ( TrimField ; 7 );""];
> 
> 
> ["¶"&RightWords ( TrimField ; 6 );""];
> 
> ["¶"&RightWords ( TrimField ; 5 );""];
> 
> ["¶"&RightWords ( TrimField ; 4 );""];
> 
> ["¶"&RightWords ( TrimField ; 3 );""];
> 
> ["¶"&RightWords ( TrimField ; 2 );""];
> 
> ["¶"&RightWords ( TrimField ; 1 ) ; ""];
> 
> ["¶" ; ""] ))
> 
> 
> 
> Thanks,
> 
> Rick
> ___________________
> Rick O’Quinn
> Photographic Services Coordinator
> University of Georgia
> Public Affairs
> Broadcast, Video & Photographic Services
> 188 Georgia Center
> Athens GA 30602-3603
> Work: (706) 542-8085
> Fax: (706) 583-0011
> [log in to unmask]
> http://www.photo.alumni.uga.edu