Validation range

[Adrian Hopkins]

I am trying to set a range of numbers to validate an entry into a field. When I set the range for example 009001000001 to 009001999999 it will allow 009001123. How can I set the range only to accept numbers with 11 digits. Sorry I am a part time user and totally lost

[Raybaudi]

Hi

those aren't numbers.

BTW, in a text field, the calc is:

Let(

number = GetAsNumber ( text );

"00" &( number ≥ 9001000001 and number ≤ 9001999999)

)

Edit: only now I'm seeing that you are on v.5 and that calc is good only for 7 and upper!

[Raybaudi]

For version 5 you can try to set two options of validation:

Data from 009001000001 to 009001999999

AND

calc:

Length (yourTextField) = 12

( 12 and not 11 are the digit that you have used for your sample )

[Adrian Hopkins]

Sorry still in the dark ages with 5.5 unlimited.

I have sorted out my problems but thank you for replies in advance

[Adrian Hopkins]

Thanks raybaudi, Just seen your second post. The problem was so simple I'm almost too embarassed to reveal I was trying to define a text field to accept strict numeric data within a certain range.

Doh. Works fine now.