Jump to content
Sign in to follow this  

Limiting string length during Data Entry

Recommended Posts


I am working on a Purchase Order db (fmp 8.5 advanced, w-xp) and I want to limit the text description to 30 characters, no more. I put max length on the field setup but it doesn't flag users that they have exceeded thirty characters until they leave the field.

Optimally, I would like the system to pop up a window that tells them when Character limit has been reached while typing in the field, not once they leave.

Any suggestions?


David R

SW Florida

Share this post

Link to post
Share on other sites

Not just what you ask, but -

You could have a button that you click to get the score. If you end the script with Set Selection the cursor never leaves the field - one click - the user won't miss a beat. It's at least smoother than clicking out to commit the field then clicking back in. And the user may not need to use it as you'll have the field sized about right (Courier?). And just in case, an auto enter calc cuts it off at 30 characters. Don't forget the TrimAll.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.