Hi Harvey, Originally I used Alex's method and made the height of the text box twice what I needed, to accommodate the overflow. But this has the effect of the report lines being effectively double spaced, except for just a few long lines. It also uses twice as much paper, if the report is printed.
So I wrote a macro that creates a second record to accommodate the overflow text. It is a bit tricky getting the second record to sort after the appropriate first record, but I have succeeded in getting it to work. I haven't attempted to modify the report's text box height dynamically - that I think would be quite tricky! If you are interested in looking at my code, (written in basic), I could post it on the list. Just let me know. Noel -- Noel Lodge lodg...@gmail.com On 23 January 2014 09:01, Harvey Nimmo <har...@nimmo.de> wrote: > On Wed, 2014-01-22 at 17:50 +0100, Alex Thurgood wrote: > > On 22/01/2014 16:40, Harvey Nimmo wrote: > > > > Hi Harvey, > > > > > > > I am fetching records from a query and putting them in various text > > > boxes in the 'detail' section of a report. Two fields of each record > > > may, however, contain more text than fit into the corresponding text > box > > > and would need to be printed on more than one line. Unfortunately, I do > > > not know how to the change the text box height dynamically to allow the > > > full text of the record field to be displayed. Obviously, if that were > > > somehow possible, also the height of the 'detail' section would have to > > > be increased for that record (and both would have to be reset for the > > > next record). The height of a text box (in the properties table) is > > > 'fixed' and I can find no attribute that would make a text box > > > 'expandable' as needed for the above. Where can I do that? > > > > Ah, that rings a bell as an oft requested feature improvement. You might > > want to wade through LO's bugzilla to see if someone hasn't already > > registered this - it may well even have come up on this mailing list > before. > > > > At present, there is no way that I know of to do what you want, other > > than making your text fields sufficiently dimensioned when creating yur > > report to take account of the odd record or two that exceeds the single > > line. > > > > Alex > > Well, it doesn't sound like a bug, but rather a feature that may or may > not be supported. > I had the thought I might try a macro, but I need help for that and > pointing in the right direction. > > Harvey > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
