Jump to content

find number of characters entered


ktstem
 Share

This topic is 5694 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm sure this is so simple, but I've never done it before! I want to find if a number field has more than 9 characters entered. Is it a find or do I have to set up a calc field?

TIA,

Kate :

P.S. This question is for FM 6, I work in a school district where we are in the process of switching to 8!

Link to comment
Share on other sites

If it is a FIND then your find request should be:

>999999999 (that's 9 nines)

If you are trying to limit the input to 9 numbers (or less) then make the field validate by calculation

length(field) < 10

Link to comment
Share on other sites

Thank you both, I don't want to limit how many characters can be entered, but I did use the length function to get the # of characters. Just used length(field). Now I can get a find off of that. How simple!!!!

Thanks again,

Kate

Link to comment
Share on other sites

This topic is 5694 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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