The following works but, there has got to be a better way.

What can be done to incorporate this into a Custom Function that can be used in other fields in this table or in other tables?

Any suggestions to improve this calc would be apreciated.

------------------------------------------

//Combine address fields into a label like field without any blank lines if data is missing

Let ( [ FN = FirstName_t ; LN = LastName_t; MN=MiddleName_t;CO=Company1_t;DP=Department1_t;L1=Address1_t;L2=AddressLineTwo1_t;CY=City1_t;ST=State1_t;Zip=Zip1_t;CT=Country_t] ;

Case(

FN="" and MN="" and LN="";"";// No name

FN="" and MN="" ;LN &

How about:

Substitute (

TrimAll (

Substitute (

TrimAll (

Title & " " & First & " " & Middle & " " & Last &

Thanks, much nicer. What is the character you are using to preserve a space with?

It's called a 'paragraph' or 'section' sign (top left key on your Mac keyboard). But you can use any character which is not likely to be found in the text.

Hi comment,

Is there a different keyboard for European users?

I have owned several different Macintosh computers, and I have never seen this as a separate key.

It is assesable by using the key combination of Option 6

According to Unipad, the

Thanks for the key combination Lee.

Hm. I do have a non-standard keyboard, but my input menu is set to use the US keyboard, so I thought if it types what's engraved upon it...

So what IS the key to the left of 1?

The ` GRAVE ACCENT and The TILDE ~ (Shift)

Lee

Interesting... I have that to the left of "z", in the bottom row.

The weird thing is I have US keyboard set as my input, and still the Keyboard Viewer matches my physical keyboard's engravings. Is it possible that the OS recognizes the keyboard and adjusts accordingly?

The Shift Key is next to the "Z" key. I have a Non Standard "wireless" M$ keyboard for my iBook. In order to use it, I had to install the software. I'm wonder if it isn't the Software that has done the remapping in some way to match the keyboard.

Lee

I haven't installed anything for this keyboard, so that can't be it. If I ever get the chance, I will connect a standard Apple (US) keyboard and see if the Keyboard Viewer adjusts to match.

What model are you using?

The keyboard, you mean? It's an Apple Pro keyboard, but it has additional engravings to accommodate some specific uses. I gather now that the underlying Latin layout is European - but my OS is not.