not more not less than 13 dig.

[tunin]

Hello all,

I need to define a field so that on data entry you can only enter 13 digits an not more not less than that (only numbers). I found the MAX but no MIN.

Thank you.

Edited January 17, 2006 by Guest

[SlimJim]

If it is a strictly 13-digit number you could perhaps do a range validation 1 followed by 12 zeroes up to 13 9's

[comment]

Hmmm.. 13 zeros is numeric only, AND has the required number of characters. Is it valid?

How about:

Length ( field ) = 13

(which also means not empty)

[tunin]

tried this, didn't work???

[tunin]

I tried this also, the only thing that works is when I leave it blank it shows my message to add a number in to that field. I can enter any muber of digits and it is OK with it???

[Lee Smith]

comments's solution works for me.

You sure you set it up as a validation?

What doesn't it do?

Lee

[tunin]

I finally got it figured out... thank you. this was fast help - almost like paramedics

Edited January 17, 2006 by Guest