Try this calculation.
fieldA & ¶ & ¶ & ¶ & fieldB
fieldA & "¶¶¶" & fieldB
Either expression works. You do not have to enclose single pilcrows in quotation marks.
I would have bet my best friend's mother's life on the fact that I had met that problem before - not enclosing the pilcrow in quotation marks. Since then, I have conscientiously enclosed them.
My best friend's mother will be very pleased.
It, (not needing quotes around a single pilcrow), was a minor behavior change that crept in a few versions back...
Does anyone then also know if it’s possible to have kind of a headline in the calculation field when I type something into text field A and another thing when I type something into text field B...?
Now I got this in my calculation field:
"Block Fuse: " & fuse_block & ¶ & ¶ & "Part Fuse: " & fuse_part
But I only want “block fuse” to appear if something is typed into the fuse_block field and “Part Fuse” when something is typed into the fuse_part field..?
Also is it possible to automatically transfer the text formatting from the two text fields into the calculation field..?
If ( Not IsEmpty ( fuse_block ) ; "Block Fuse:" & Fuse_Block & "¶¶" ) & If ( Not IsEmpty ( fuse_part ) ; "Part Fuse: " & fuse_part )
is it possible to automatically transfer the text formatting from the two text fields into the calculation field.
That would depend on how the text in those fields get formatted. If the formatting is applied to the text fields when in layout mode, it is not possible.
No it's done when in browse mode, just want to transfer the text properties bold, italic, color etc...?
also is it possible only to make the "Block Fuse:" bold..?
My tests indicate that styles applied to the individual text fields will be reproduced in the text returned by a calculation field. If I select a word in a text field and specify Bold or a color, A calculation field that references this same text field shows the same selected text as Bold or a different color.
You can use ... & TextstyleAdd ( "Block Fuse" ; bold ) & ...
inside the If function.
But why do you need this calculation? It occurs to me that it is possible that you do not need this calculation field at all as there are ways to get this result on your layout without having to define a calculation field.