Version FMP 9.0v3A

I have a calculated field that simply combines contact information to
make a mailing address field. The problem is that some of the records
were entered with some data in caps and some in title case. I want it
to all show as titlecase.

I=92ve tried setting the MailingAddress field to Titlecase in Layout, but
it doesn=92t work. I=92ve tried a calculation, but it doesn=92t work:

TextStyleAdd (
Name_FullName_FirstLast & "=B6" &
If (IsEmpty ( Address1 ) ; "" ; Address1 & "=B6" ) &
If (IsEmpty ( Address2 ) ; "" ; Address2 & "=B6" ) &
If ( IsEmpty ( City) ; "" ; City & ", " )
; "Titlecase" ) &
TextStyleAdd (State ; "Uppercase" ) & " " & Zip5

This is suppose to set all to titlecase except the state, whichis
uppercase. Not working.

Any suggestions?

--
Russ Carlson
Bear, DE USA


#############################################################
This message is sent to you because you are subscribed to
the mailing list <fmpro@lists.lassosoft.com>.
To unsubscribe, E-mail to: <fmpro-off@lists.lassosoft.com>
To switch to the DIGEST mode, E-mail to <fmpro-digest@lists.lassosoft.com>
To switch to the INDEX mode, E-mail to <fmpro-index@lists.lassosoft.com>
Send administrative queries to <fmpro-request@lists.lassosoft.com>