strange concatenation phenomenon

[macavity]

I don't know what else to call it.

This didn't happen in FileMaker 6 and I'm at a loss: If you string together text and a field from a related table, either in a concatenated field or as a merge field, FileMaker insists on making a new line of everything beyond the field content, including the initial space after the ". It doesn't do it if the field is in the same table, however. The workaround is obvious, but I hate to create unnecessary fields just for the purpose.

Is there another way?

[Genx]

Huh?

Can you post a screen shot?

[macavity]

OK.

First the field in layout mode. Nice and long.

Second what appears in browse mode.

Can't add more than two files, so continues in next post.

[macavity]

Then add a second line to layout

and you get the rest of the contents of the field in the second line, including the initial space.

(ggds....) is the contents of the related field :

Posting the definition next...

[macavity]

Here's how the field was defined.

Exactly the same thing happens if I write the text in the layout and include the related field as a merge field. It doesn't happen in either case if the field is from the same table.

[Genx]

Whats in that related field... are you sure there isn't a paragraph?

Try this just incase:

"Line one " & Substitute( yourfield ; "¶" ; "") & " the rest"

If that display's correctly then you have a paragraph in your related field.. If it doesn't display correctly welll... Ah, replicate the problem in another field and post it.

Cheers

[LaRetta]

It works fine for me. Can you post a layout shot of your Bild_4.png shot? You might be jumping from various examples and not pinning down the problem ... it happens sometimes when testing.

Can you also read me your Format > Line Spacing > Custom settings (after selecting the field)?

LaRetta

[IdealData]

Here's one that doesn't do it

Untitled.fp7.zip

[macavity]

Eureka. Thank you for your help.

It seems there was a paragraph in the related field - because it is the result of a Get Value;1 function. Apparently that includes the carriage return at the end of the first line. Should have occurred to me. Thanks for putting me on the right track!

[David Jondreau]

GetValue should not include a pilcrow. LeftValues will though. Maybe that's what you're using?

[macavity]

Sorry, you're right, it was LeftValues...