dbTalk Databases Forums  

limit the typed text in a field

comp.databases.filemaker comp.databases.filemaker


Discuss limit the typed text in a field in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hatzigiannakis Nikos
 
Posts: n/a

Default limit the typed text in a field - 02-26-2007 , 12:48 AM






1. Is it possible to limit the number of characters allowed to be typed in
a field?

E.g I want the user not to type more than 10 characters in a given field.

2. Is it possible to allow only digits to be typed in a fileld?



Reply With Quote
  #2  
Old   
Ursus
 
Posts: n/a

Default Re: limit the typed text in a field - 02-26-2007 , 04:02 AM






presuming FMP 7 or up. PLEASE state version with all your questions.

1. Yes, but not in a way that filemaker wil react on the moment the 11th
character is typed. It can be made so it protests when the field is
validated. Either by tabbing out, creating a new record or a number of other
actions.

Here is how you do it. create a text field <one>, goto options, select tab
validation, Disable the tick next to "Allow user to override....."
Click the button specify, in the validation window enter the following
calculation: Length(one)<11.
Set the option to display a custom message, type something like "This field
has a maximum length of 10 characters"

2 Yes, basicly you want the user to enter a number. Create a number field
<two>, goto options, goto validation, Disable the tick next to "Allow user
to override..... Set the option under Require, Strict data type and select
Numeric only from the dropdown. Enter a custom message if you want one.

Keep well, Ursus


"Hatzigiannakis Nikos" <nikos (AT) ypai (DOT) gr> schreef in bericht
news:eru07d$mov$1 (AT) volcano1 (DOT) grnet.gr...
Quote:
1. Is it possible to limit the number of characters allowed to be typed
in a field?

E.g I want the user not to type more than 10 characters in a given field.

2. Is it possible to allow only digits to be typed in a fileld?




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.