miguel01

Thank you very much LaRetta! your question helped me very much. I made an example file. And doing it I found the mistake: The calculation field must be on text modus to show the format without clicking. I checked also the textsize. I told the field to have a scrollbar. So it is a scrollable calculation field. For all others who might have the same problem I attach the example file . calculationfield_showing_textformat_with_scrollbar.zip

thank you very much raybaudi! It works! I had to let away the result()tag, because a popup window asked me for a calculation(+,-,&)instead of: Left ( result ; Length ( result ) - 1 ) . But as long it works without result(), that's fine. Now I'm just wondering how to show the nice textformat without clicking on the field... I've put a new thread on this question: http://fmforums.com/forum/showtopic.php?tid/200453/ thank you for your advice! m

I format some text in a calculation field like this: If ( not IsEmpty ( Line1 ) ; TextStyleAdd ( "On Line 1 we have " ; Bold ) & Line1 & ¶ ) You see the TextSyle only if you click on the field. Do you know a solution to show the format without clicking on the field? thank you!

Thank you comment for your suggestion. For the moment I use the conditional formatting. Because I use some header between the lines, if they appear. in a calculationfield I can't programm diffrent formating of the text in a same field. Isn't it? Or can you include html like formatting in a calculation field or a script: If (Line1 = "";"[b]On Line 1 we have[/b]"; "")Line1 Titanium mailed me, having the same problem I’ve only found the possibility to hide a field (giving to it the same color as the background) or showing it, when it has content. But this way you will always have to reserve the space in your layout for the field. This solution you realize by right-clicking on the field ( in layout modus) and choosing “conditional formatting”. On the popping up window you can adapt all your needs for conditional formatting. What I was interested in, was to not display the field at all, when it is empty. For that I didn’t find a solution...yet

Thank you aldipalo! I did it sucessfully like this. Does someone know [color:orange]anotherway to show a field only under the circumstance of another field?. With the solution of conditional formating we have to keep the space reserved for the field appearing. But I would like to have a same space where diffrent fields could appear. In details: I have 6 diffrent fields: "line1" "line2" ..."line6" which use to be shown or not. Sometimes there is only one of the fields showing. If i.e. only "line6" shows up I would like to show the content of "line6" on top. (With conditional formatting I have to keep the space for "line1" to "line5" open, therfore "line6" shows up only at the end of page, even if "line1to5" don't have content) thank you in advance to everybody who knows a solution!

[color:blue]My main question is: Is it possible to show in the Layout a certain field only if another field has a content? Does someone have experience with this kind of solutions? thank you in advance! miguel [color:blue] My problem in detail: I'm doing a database for i ging queries case 1 If i.e the first line of the hexagram changes, the field "line1_changing" is showing his number (for example 34.1 for hexagram 34 line 1) Otherwise I keep the field "line1_changing" empty. Now I want to show the field "line1_comment" only if the field "line1_changing" has a entry. case 2: the 64 hexagrams and their 6Lines have one table together (they have IDs (up to 448) but also an ID 1, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 2, 2.1...64.6). When it is a line I would like to show the field "text_of_the_line" when it is the hexagram I would like to show the field "hexagram_judgement".