Another "Novice" Question about UPPER(text) Fn

[RBSolutions]

Okay.....

Here we go again... I've searched through to see if anyone has already posted a similar issue but I didn't find one. This question is going to seem so elementary that I hesitate to ask. Still, the dbase must be completed so.. here goes.

Currently running FMP5.5

I have a report set up to print mailing labels using the standard template available. Fields are listed like this in the Layout mode.

[color:"blue"]<FirstName> <LastName>

<Address1>

<Address2>

<City>, <State> <zip>

Everything prints the way it's supposed to except, obviously, <State>.

<State> is a text field and, on my other layouts, I've set it to UPPERCASE. Of course, on the Labels layout, you can't do that because it's more of a merge setup than a field layout.

So, here's the deal, I thought I'd use the UPPER function to simply set the field to always be in uppercase no matter where it occurs....

Tried setting it under;

--> Define Fields

------> Options

------------> Calculation

and tried setting the field itself to a Calc field and entering UPPER(State).

In each case, I get the circular definition error.

Would I be better off to just set up another field? I'm kinda at a loss on this one.

Thanks in advance.

Dan'l

[balooka]

hi

If you set your merged <<text>> to UPPERCASE it will show up correctly... [format/style/uppercase].

well, at least on the little test I just did

HTH

JP

[Lee Smith]

Dan'l

In layout mode, select the State field and then under the menu, selcect "text" and format it to UPPERCASE.

That should do what you are asking.

BTW, these are Merge fieldsand when referring to them you should insert both << field >>. Tip of the day,, and you can get by by formatting just the first "<" <State>>

HTH

Lee

[RBSolutions]

Lee, Balooka;

Thanks, that was it. My problem was that I was trying to make it too difficult. (I think the << >> around the merge field scared me off)

Thanks again,

Dan'l