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!

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

Look up the Length function in your online Help, and also Boolean (True/ False) values.

Lee

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