Hi Laura, I defined a new field like this: Left (Justification ; 250), then placed it over the Justification field. Now I have two more problems: 1. I can only get to the Justification field with Tab, not the mouse click. So it will be more difficult modify the field later 2. The new field only shows up after I finished typing and exits the Justification field. Did I define the calc field correctly? I thought "Left (Justification ; 250)" is the same as If ( Length ( Justification ) < 250; Justification ; Left (Justification ; 250) ) Thanks, Yao
>>> Helping Hand Database Design <[EMAIL PROTECTED]> 11/30/2006 2:24 PM >>> Here's a thought : How about a second field (calc) with an If statement that counts characters. If it exceeds a limit, Truncate to that limit. Let that field be the display field - perhaps placed directly over the typing field? Also use that calc field for whatever other purpose you have the original field set to do. HTH, Laura Laura Zantzinger Helping Hand Database Design FileMaker Solutions Alliance Associate Member [EMAIL PROTECTED] www.ureach.com/helpinghand 877-538-2088 PO Box 276 Barnard, VT 05031 ---- On , Yao Chen ([EMAIL PROTECTED]) wrote: Thank you for your help, Laura. Sorry that I didn't explain the problem clearly. I did set the limit, such as 250 characters. A user can type 260, 500 or more characters, then when he/she goes to other fields, a message dialog shows up. I want to skip the second step, so the user won't be able type more 250 characters. I know in HTML, it is very easy to set the field limit that a user can type up to 250 characters. I am wondering if FileMaker 8.5 can do the same thing? Thanks, Yao >>> Helping Hand Database Design <[EMAIL PROTECTED]> 11/30/2006 2:09 PM >>> Yes, look at the Validation tab on the options for your field in define database. There is a maximum number of characters option. You can choose your number and also what the dialog will say if a user exceeds the limit. Enjoy, Laura Laura Zantzinger Helping Hand Database Design FileMaker Solutions Alliance Associate Member [EMAIL PROTECTED] www.ureach.com/helpinghand 877-538-2088 PO Box 276 Barnard, VT 05031 ---- On , Yao Chen ([EMAIL PROTECTED]) wrote: Can the filed be set to limit the number of characters entered without having to wait to exit the field to learn you've exceeded the limit? Thanks, Yao
