Verily you are the Goddess of Reporting. < s > This little tidbit (especially the tip about the invisible line) is one of the most valuable I've ever seen re: the somewhat arcane VFP report writer. Must have missed it if it was in your excellent book, but I'm memorizing this one.
See you in Toledo
>You don't have to move the rest of the objects to the footer. Leave them in the memo band and mark all the object beneath the memo field as float.
>
>In another message, you mentioned that they were "text" and you couldn't mark them as float. I'm not exactly sure what you mean because text (or label) objects can float just like field object. I'm wondering if what you meant was that you can check the float option, but it doesn't behave as you expected. If that's the case then here's an explanation of how float works:
>
>Objects marked as float only look DIRECTLY ABOVE itself to see anything stretched. By directly above I mean that it only looks above in the exact width of the object it's checking. That means if you have some text off to the side of something that stretched, it won't recognize that you want it to float too because nothing "directly above" it floated.
>
>To get around this issue, put a horiztonal line directly beneath the memo field, making it as wide as the report (or wide enough to span across any objects you want to stretch). Mark the line as "float" and change the Pen Style to "None" so the line doesn't actually show up. This fakes out the report writer and now when the objects beneath the line need to check whether to float or not, they see that the line floated so they will float.
>
>Cathy
>
>
>
>>Hi
>>
>>I have a report which includes a memo field alltrim(clinotes) with stretch on overflow. This is overprinting the text below it. I have then moved the text to the page footer but I now have a gap of about 2 inches between the memo field and the text even though the divider between the page and the page footer is hard up against the memo field on the one hand and the text on the other.
>>
>>Any bright ideas
>>
>>Colin Northway
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
