Is there a way to dynamically set the height of the field? I am trying to concatenate contents of multiple fields text fields into one. As the contents of individual fields are not known, I am wondering if there is a way to dynamically set the height of the concatenated field ?

Thanks for your help...

Field height (even calculation text field height) is determined by the layout where that field is placed. If you create a calculation field based upon the concatenated text and set the text size then all text within that calculation will take the same height.

If you want the text to be different sizes, you must control that within the calculation using the TextSize() function. All text in your database should remain the same size and, as your needs change, change the size of the display of the text from different layouts.

UPDATE: The above is true also if you use a merge field and place all the data within the same text block. The data will take the attribute text size assigned to the layout object, ie, the merge field itself. As for width, you must make the field block large enough to display all the information if you want it all to display. Otherwise, a User may have to click into the field to see all the text.

More information would help here ... if you are creating a report, you can control text-block sizes using the sliding options.

Edited October 26, 200817 yr by Guest
Added update

Hold up ... I'm basing it on the fact that all text (original field text) is the same size (which it should be). If your text is actually different sizes then the concatenated calc will indeed display them different sizes! You will need to wrap your concatenation with TextSize ( yourConcatenation ; size ).

But again, all text should be same size so you don't have to deal with mixed size issues.

Are you asking about how to make the field to grow, or shrink to accomodate the number of charaters depending on how big or little the number of characters there are?

If so, you will need to make the field as big as it needs to be, so that all text will show in browse mode, and then use the Slide Options in Layout >> Format >> Slide Print, and/or format the field with Scroll Bars.

HTH

Lee

LaRetta and Lee,

Thank you both for such quick reply. Lee's assumption of my problem is more accurate. I will try what you suggested and see how it prints.

Basically, I would like to concatenate from 7 different text fields. The contents of these 7 fields are of variable length. I would like my concatenated field to grow/shrink depending on the length of the 7 fields. The objective is also, to be able to print the contents of the concatenated field. Lee, thank you and LoRetta, thank you as well

I have another qts !. Is it possible to display reports through a web-browser, including summaries and Grand Summaries?

Please help !