Also use Auto Enter by Calculation (ensure that you set it to always
replace existing value !) with the formula:
Proper ( text_field )
This is in itself an event trigger run by a field level option you can
set in field definitions
On 21 Apr 2005, at 17:55, Ralph Lilienkamp wrote:
Charu 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
The Proper function will change the first character of every word to
upper case. You will nee an event trigger plug-in to start the
script. Look at EventScript at http://www.softs4humans.com. It is
donnationware.
--
Ralph
[EMAIL PROTECTED]
--
To unsubscribe: send an email to <[EMAIL PROTECTED]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
Regards
Harry Catharell **FileMaker Certified Developer**
MaJic Solutions Limited - FileMaker Partner
t: +44(0)1908 236678 w: http:://www.majic.co.uk
++ FileMaker EXCELLENCE AWARD WINNERS - DevCon 2004 ++
--
To unsubscribe: send an email to <[EMAIL PROTECTED]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
