What would be the easiest way to limit a field to 45 characters? I would prefer something that comes up as soon as they left that field alerting them if it's too long.

Thanks

-j

[ March 29, 2002, 08:53 AM: Message edited by: nightdesigns ]

"Maximum number of characters" is now one of the options for Validation in the Define Fields dialog.

For version 5.0 and earlier, set the field validation for the "TExt" to:

code:

---

If(Length(TExt)>44,0,1)

and display a message like "Toooooo Long" if the validation fails.

This will only work once you try to leave the "TExt" field

quote:

---

Originally posted by Fitch:

"Maximum number of characters" is now one of the options for Validation in the Define Fields dialog.

---

That would be for v5.5 I presume; v5.0 doesn't have this feature.

For earlier versions, you can create a calc field to return a message if the data entry field is too long -- be sure to go into "storage options" and check the "Do not store..." box. The problem is that the calc field doesn't calculate while you're entering data in the entry field; it waits until you exit that field.

quote:

---

Originally posted by Russell Baker:

For version 5.0 and earlier, set the field validation for the "TExt" to:

code:

---

If(Length(TExt)>44,0,1)

and display a message like "Toooooo Long" if the validation fails.

This will only work once you try to leave the "TExt" field

---

Works great, thanks.