FileMaker Pro Custom Functions

Search  |  List  |  Show Random  |  Upload  |  Add This to Your Site

ActualLineCount ( Text ; CharsPerLine )

Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/

Determine if text is overflowing field bounds on layout.

Description:

Have you ever needed to know if data is overflowing the boundaries of the field in which it is being displayed? For example, maybe you want to use conditional formatting to notify the user that they have entered too much text to be displayed on a printout. This can be a tricky thing to determine when data can contain carriage returns.

This custom function will solve the problem for you, with a couple of caveats:

- You need to use a monospace font on the field

- You can not allow tabs in your data because it is impossible to determine where the tab stops are. Since you have to use a monospace font anyway, you can use an autoenter calc to replace tabs with 4 spaces.

- You might want to add a platform check to address font size differences on Mac and Windows.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

digg this page | del.icio.us this page

Download the Custom Function Dashboard Widget for OS X Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions: 1. PVofFV ( FutureVal , Interest , Term )   (Sat, May 10, 6:52pm) 2. Edate ( thedate ; months )   (Sat, May 10, 5:21pm) 3. FormatDate( DatetoFormat )   (Thu, May 08, 6:05pm)

Custom Function Authors:
Link to all of your own custom functions on this site with the following URL:
http://www.briandunning.com/filemaker-custom-functions/results.php?author=Your Name Here