number field to text

[gloerick]

Hello All,

Can someone please help me on a layout, I am making a layout to look like a personel check.

Please how to take the number of the total say 10.95 and turn it into text such as

ten & 95/100 or $106.30 into say

One Hundred six & $30/100 for the text line

of the dollar amount on checks.

Any help please

Thx,

Erick

[Vaughan]

Go to Brain Dunning's we site, there are a couple of custom functions to do this...

http://www.briandunning.com/filemaker-custom-functions/

You'll need FMP Advanced to add custom functions to a file.

I just saw you're using FMP 6... might be time to upgrade.

[comment]

Perhaps this ancient thing might help:

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=2860

I never tested it, so I don't know how well it works.

[gloerick]

MAN THANKS,

This was absolutly perfect, gives the text for the dollar amount.

now I can print customers checks right from filemaker, thx so much.

Erick