I work in the music business. Over the years songwriters have emailed their lyrics to me. I have copied and pasted these lyrics into a regular text field in my database. After I get the text into the field, I change most of the text to UPPERCASE. If, at a later date, I copy this text out of the field and paste it into the body of an outgoing email, my UPPERCASE adjustments to the lyric are gone ... the lyric reverts back to its original format. This does not happen if I copy the lyric from my database into a Word Document. Any thoughts on what I'm doing wrong? Please don't tell me that I need to go through every record in my database and manually change something ;-)

If you want all the text in the field to be uppercase, you could do a simple replace using FileMaker's Upper function. If you only want some, not all, of the text upper it could be tricky.

Hi Tom,

The text in the field is not all CAPS.

When you set a field to display UPPERCASE from the layout level, that does not actually change the data itself (even though if you click into the field it appears that the data changed).

Microsoft Word and Outlook handle it differently ... Word knows to keep the formatting in the paste and Outlook does not. This is easily replicated and you are correct that it is not consistent.

What Tom is suggesting, I believe, is to create a calculation (result is text) as:

Upper ( yourField ) and use the calculation when setting your email. The results would then be consistent.

So to explain: Layout level formatting takes text and makes it ALL CAPS if you specify 'uppercase' but a calculation requires wrapping the field with Upper() to make it all cap. And some programs recognize to keep clipboard contents with formatting (at least on the Windows platform this is is true) and some don't but the calculation approach is actually changing the data so your email will see it properly.

I'm not actually cutting and pasting the text into an email ... The email where the text is ending up is being created through the "Send Mail" script step. In the "Message" portion of the "Send Mail" script step I'm referencing the text field that is in question (text_field_1). Through a script step prior to the "Send Mail" script step, I've tried copying and pasting text_field_1 into another text field (text_field_2). "text_field_2" has an Auto-Enter Calculated value of: Upper (text_field_2). After doing all of this, the all CAPS are still not showing up in the message area of the email. I must be doing something wrong?:)

The calculation needs to be type 'calculation' and not standard text field with auto-enter calculation to properly update.

My apology for misunderstanding but you DID say repeatedly in the opening post that you copy/pasted into your text field and then copy/pasted into the email and 'copied' etc. Well, I hope the calculation works instead of standard field. :wink2:

SO SORRY ... For not being clear enough.

The calculation field is working

THANK YOU SO MUCH !!!

The text in the field is not all CAPS.

Isn't that a problem anymore ?

( if it is, try the file attached )

Edit: file trashed: wasn't perfect.

Edited July 23, 201015 yr by Guest
delete the file

What exactly does your file do?

I gave too much confidence in a CF not mine.