length

Syndicate content

You can limit the number of characters end users can enter or store in a field. Use this feature to help avoid data-entry mistakes in text fields. Carriage returns count as one character. To learn how, please see our Set Maximum Length for Entries in a Text Field help topic.

February 5th, 2009 - 6:02 PM

Let's assume the text field is called "Notes". Create a formula text field with the following formula:

Left([Notes], 100) &
" " & URLRoot() & "db/" &
dbid() &
"?a=dr&rid=" &
[Record ID#] &
"&dfid=11"

where the number eleven above is the identifier of the custom form that displays only the field "Notes". To determine the dfid of your custom form please read:

February 5th, 2009 - 6:02 PM

If you want to restrict the number of characters in a text field, please see our Set Maximum Length for Entries in a Text Field help topic.

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit