Limit Amount of Characters? 
Author Message
 Limit Amount of Characters?
Hi,

New to FMP 5.0.

Is there a way to limit the amount of characters entered in a field? For
example, only three numbers per field such as for area code?

--
Thanks,
Cesar A. Iriarte
Systems Director

|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

 Iris Internet Solutions
  http://www.***.com/


  phone: 361.884.9000
  fax: 361.883.1786
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||



Mon, 03 Nov 2003 23:43:34 GMT
 Limit Amount of Characters?

Just a guess as I'm new to FM myself, but couldn't you use a validation
using length(FieldName) = xxx ?

Now, if you're looking for something like a browser where it physically
won't allow you to enter more than 3 characters I'm not sure if that's
possible in FM.

-warner



Quote:
> Hi,

> New to FMP 5.0.

> Is there a way to limit the amount of characters entered in a field? For
> example, only three numbers per field such as for area code?

> --
> Thanks,
> Cesar A. Iriarte
> Systems Director

> |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

>  Iris Internet Solutions
>   http://www.ciris.net


>   phone: 361.884.9000
>   fax: 361.883.1786
> |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||



Tue, 04 Nov 2003 01:28:45 GMT
 Limit Amount of Characters?

Quote:
>Hi,

>New to FMP 5.0.

>Is there a way to limit the amount of characters entered in a
>field? For example, only three numbers per field such as for
>area code?

>Thanks,
>Cesar A. Iriarte
>Systems Director

You should get the idea from the last posting to your first question and the
email that I just sent you, but basically, you would need to use a validation
and in the calculation you would enter the following:

Length(<field>) = xxx

You can also use >, >=, <, and <= in place of the = in the formula above to
restrict size or ensure at least a given length.

Hope that this helps...

Bill
--------------
The box listed as the requirements:  Windows95 or better
...so I bought a Macintosh.

(Remove nospam from email address)



Tue, 04 Nov 2003 02:03:14 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Limiting amount of characters in a field?

2. How to get around 4000 character limit with character functions

3. limit amount of data in Cube how???

4. Limiting amount of recources to SQL Server

5. limiting the amount of SQL logins

6. Limiting the amount of data returned

7. Limiting amount of rows returned from a query.

8. Foxpro 2.6 limiting the amount of users

9. Limiting amount of data to an Access 2000 report

10. Amounts in figure to be transformed in amounts in letters

11. Amounts in figure to be transformed in amounts in letters

12. Numeral amount to italian literal amount


 
Powered by phpBB® Forum Software