Hello Yao,
For a text field called TextField, set the autoenter calculation for
the field as:
Left (TextField; 250)
Make sure the "Do not replace existing value of the field..." is
unchecked.
It doesn't prevent it, it just ignores any additional characters and
restricts it to 250... similar to your html example.
As a warning to users, you can place the validation for a maximum of
250 characters, with a message that their data has been truncated
(with the "Allow override..." unchecked, so they don't get the false
impression that they have control over it).
Best wishes,
Beatrice Beaubien, Ph.D.
i2eye, Toronto, Canada
Associate, FileMaker Solutions Alliance
FileMaker 7 Certified
On Nov 30, 2006, at 14:19:07, Yao Chen 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
