In the field definitions for your Name field enter the following calculation:
<x-tad-smaller>Upper ( Left ( Name_Field ; 1 )) & Lower ( Right ( Name_Field ; Length ( Name_Field ) - 1 ) )
and un-check the "Do not replace existing value of field (if any)" option.
Obviously you have to be aware of existing auto-enter calculations and people entering more than one name in the field...
Lee
</x-tad-smaller>
On 21 Apr 2005, at 17:36, Charu Trikannad wrote:
Hi,
I am using FMP-Pro 7.
I have VB, Oracle and Progress background in programming that was 7 years ago. This is my first project on FMPro. I am accepting a Name (Text field) on the form and I would like it to be stored in the database with first character in uppercase. I am aware of the Text functions to extract the first character and then use UPPER to convert it to Upper case, and then concatenate with the rest of the characters in the name field. How am I going to trigger this script as there is no way of triggering a script after exiting a field? I don't want to use Buttons to run a script.
Thanks for your help in advance.
Charu
----- Original Message ----- From: "Justin Mattson" <[EMAIL PROTECTED]>
To: "Filemaker Experts" <[email protected]>
Sent: Thursday, April 21, 2005 11:16 AM
Subject: Re: Zip?Expander
On Thursday, April 21, 2005, at 11:05 AM, Jeff Hough wrote:
As a point of clarification, Apple accommodates extensions on files. Also, since OS X is based on Linux, the extensions are not limited to 3 characters.
Because I am a bit of an Apple fanatic and fanboy, I want it to be clear that OS X is based on FreeBSD, not Linux, and yes, there is a difference. Its also based on the Mach microkernel (developed at Carnegie Mellon) and the NeXT application frameworks.
Justin
--
To unsubscribe: send an email to <[EMAIL PROTECTED]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
--
To unsubscribe: send an email to <[EMAIL PROTECTED]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
