Ok, Im really lost..... I'm trying to understand why when I concatenate multiple fields into one single field using a calculation field, The field data on my layout doesn't show just a single line of text...

 

 

Here's my Calculation Field:

 

TextA &" "& B::TextB &" " & C::TextC

 

 

and a REAL simple Related DB is Attached to review

 

Thank You

 

-sr

 

 

Relationships.fmp12.zip

because you are concatenating everything into one long string.  If you want multiple lines you need to use the return character (pill-crow) instead of a space between the values.

Text A has a return in the text in the field, so naturally it will be in the concatenated field. If your data may have extra returns embedded, you will have to substitute for the returns in your calculation:

 

Substitute(TextA &" "& B::TextB &" " & C::TextC; ¶; "")

Take a look at the Trim4() custom function, on Brian Dunning's web site. I's great for stripping off all leading and trailing white space from text.

Wow, Ok....... so I'll admit I was a little tired and burnt to a crisp, So thank you everyone, for keeping my sanity

 

Thanks Again

 

-sr